rdbconcepts
asked on
Setup issues with mirroring (2008 r2)
Hi
I am trying to set up high performance mirroring between a primary server (ps1) and a secondary server (ss1)
When i tell the mirroring to start, the following error appears;
TITLE: Database Properties
-------------------------- ----
An error occurred while starting mirroring.
-------------------------- ----
ADDITIONAL INFORMATION:
Alter failed for Database 'Sue_Test'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&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://<SS1<.<domain>.loca l: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.50.4000&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
-------------------------- ----
BUTTONS:
OK
-------------------------- ----
I have checked that the ports are enabled, checked that I can see the SS1 from PS1 and have checked that the account that starts the services on each side has permissions.
Please can anyone advise me what else I need to do?
Thanks
Sue
I am trying to set up high performance mirroring between a primary server (ps1) and a secondary server (ss1)
When i tell the mirroring to start, the following error appears;
TITLE: Database Properties
--------------------------
An error occurred while starting mirroring.
--------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'Sue_Test'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&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
--------------------------
The server network address "TCP://<SS1<.<domain>.loca
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
I have checked that the ports are enabled, checked that I can see the SS1 from PS1 and have checked that the account that starts the services on each side has permissions.
Please can anyone advise me what else I need to do?
Thanks
Sue
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No problem - glad you make it work...
ASKER
Ive accepted my own solution simply because I worked it out before I was given the answer - it was just permissions that I hadnt thought to check
How did you set it up - using the wizzard?