July 10, 2009 at 2:14 am
Hello All ,
Can you please tell me about database mirroring configuration setup
I have created principal and mirror servers and before that i have done following step
Principal Server:(Which is on remote server)
-take a backup
-save it on principal server
-copy it to mirror server
Mirror Server:(Which is my local system)
-Restore the database .
I only restore the .Bak only and unable to restore the .log file (it gives error)
After that i have done the following steps
1)Right Click +Properties+Mirroring
2)Click on Configure Security+Next
3)I dont want WITNESS
4)Next
5)It automatically display Port no 5022 and EndPoint : Mirroring for principal and Mirror Server respectively.
6)I will give Service Account as
xxxx\administartor(for Principal)
and xxxx\sarang (for Mirror)
7)It gives successful message
8)But when click on Start Mirroring Button following error message is displayed
The server network address "TCP://indserver.xxxx.local:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)
so any on ecan please send me exact solution over this
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 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply