I am configuring mirroring on two sql 2008 servers. I have a principle server and a standby server with a restored database (in NORECOVERY mode).
When I choose to mirror, and then choose the primary and mirror server...I get the following error. Now, i can connect to both servers, ping each other and with DNS, can telnet to each respective port on 5022 so its not a connectivity issue.
TITLE: Database Properties
--------------------------
----
An error occurred while starting mirroring.
--------------------------
----
ADDITIONAL INFORMATION:
Alter failed for Database 'GGConnectV3'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
--------------------------
----
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
ctionInfo)
--------------------------
----
The server network address "TCP://WIN-4DL3VZ7HITK.cor
p.cluster.
net:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
--------------------------
----
BUTTONS:
OK
--------------------------
----
Can it be a user security issue?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
This award recognizes a member of Experts Exchange who has made outstanding contributions to the community within their first year as an expert. The Rookie of the Year is awarded to a new expert who has the highest number of quality contributions.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.