July 10, 2009 at 9:18 am
See if this helps you
July 12, 2009 at 2:39 pm
You have to create TCP endpoints on Primary and on Mirror server and then you have to grant connect permission on both servers.
February 4, 2013 at 8:36 am
Guys,
The error is misleading while the solution is pretty simple and straight..
Server A --> principal --> domain\Servic_Account1
Server B --> Mirror --> domain\Servic_Account2
Make sure domain\Servic_Account1 has sysadmin rights on Server B
and the same way domain\Servic_Account2 has sysadmin rights on Server A.
Set up the mirroring again and you should be good with out any errors.
April 19, 2013 at 3:07 am
We have did that still unable to start the mirror in the server.Check the attached screenshot.
April 19, 2013 at 3:15 am
An Error occured while starting Mirroring.
Additional information:
Alter failed for Database 'testbest_DB'.(Microsoft.Sqlserver.Smo)
An Exception occured while executing a Transact-SQL staement or Batch.(Microsoft.SqlServer.ConnectionInfo)
The server network address "TCP:dbserver1:5022" can not be reached or does not exist.Check the network addess name and that the ports for local and remove endpoints are operatioanal
I am getting this error while star mirroring,
June 6, 2013 at 3:47 am
1) Run SQL services and SQl Agent with Same Account on Both server.
2) Check Telnet is working on same port.
3) Try to keep ldf and mdf path same drive for both server.
Any Issue Let me know.
June 27, 2013 at 4:03 am
Configure SQl mirror with following reference....
MS SQL 2008 Server Mirroring Guide..... http://mytecharticle.com/?p=279
Viewing 7 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply