Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database mirrioring Error (Microsoft SQL Server, Error: 1418) Expand / Collapse
Author
Message
Posted Friday, July 10, 2009 2:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 02, 2010 12:33 AM
Points: 7, Visits: 13
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 ServerWhich is on remote server)

-take a backup
-save it on principal server
-copy it to mirror server

Mirror ServerWhich 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
Post #750880
Posted Friday, July 10, 2009 9:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:58 PM
Points: 1,141, Visits: 944
See if this helps you

http://msdn.microsoft.com/en-us/library/aa337361.aspx
Post #751166
Posted Sunday, July 12, 2009 2:39 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Sunday, March 30, 2014 10:24 PM
Points: 673, Visits: 556
You have to create TCP endpoints on Primary and on Mirror server and then you have to grant connect permission on both servers.

Post #751756
Posted Monday, February 04, 2013 8:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 1:38 PM
Points: 5, Visits: 80
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.
Post #1415346
Posted Friday, April 19, 2013 3:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 1:57 AM
Points: 6, Visits: 7
We have did that still unable to start the mirror in the server.Check the attached screenshot.
Post #1444281
Posted Friday, April 19, 2013 3:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 1:57 AM
Points: 6, Visits: 7
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,
Post #1444285
Posted Thursday, June 06, 2013 3:47 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 10:53 PM
Points: 62, Visits: 320
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.
Post #1460599
Posted Thursday, June 27, 2013 4:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 1:57 AM
Points: 6, Visits: 7
Configure SQl mirror with following reference....

MS SQL 2008 Server Mirroring Guide..... http://mytecharticle.com/?p=279
Post #1468062
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse