SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Mirroring Error


Database Mirroring Error

Author
Message
Bhushan Kalla
Bhushan Kalla
SSC-Enthusiastic
SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)

Group: General Forum Members
Points: 195 Visits: 71
Hi Everyone,

I setup database mirroring between two NAMED instances on two different servers. After completeing the database mirroring configuration, I clicked on Start Mirroring button then I got below error message. Both Named instances are running on other than default ports (1434) and mirror endpoints ports are 5022.



An Error occurred while starting mirroring



Alter failed for Database Test (Microsoft.SqlServer.Smo)



An exception occured while executing a Transact-SQL statement or batch.



Alter Database Command failed due to an invalid server connection string. (Microsoft SQL server, Error: 1449).



For testing purpose, I installed two named instances on same test box and configured database mirroring and that is working fine. so it seems the problems with two instances on DIFFERENT Servers.



Any help is greatly appreciated.
ChiragNS
ChiragNS
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3509 Visits: 1865
Hi



Error message says "invalid connection string". Check the connection relate things , user accounts under which the 2 instances are running etc..

"Keep Trying"
Steve Jones
Steve Jones
SSC Guru
SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)

Group: Administrators
Points: 65447 Visits: 19118
Agree with Chirag, you must have some connection string mis-configuration.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Rajni Kant Ranjan
Rajni Kant Ranjan
SSC Veteran
SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)

Group: General Forum Members
Points: 200 Visits: 500
Hi!



as per your error you have to check the service login id of both servers and connection userid and password of both servers. Becuase problem is only with these things.





Thanks & regards

Rajni Kant Ranjan
Suvendu
Suvendu
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 73
To begin mirroring select Start Mirroring and the mirroring process will begin.
Make sure you have restored your backup on the mirror instance or this process will not work.
If you need to make changes select Do Not Start Mirroring and make the adjustments or do the restore if you have not done so already.
rajkumar854
rajkumar854
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 12
this is is all nonsance. every body know it and hav tried these step still the same error is coming now what to do.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search