Database Mirroring Error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Database Mirroring Error

Database Mirroring Error

Rate Topic

Display Mode

Topic Options

Author

Message

Bhushan Kalla

Posted Thursday, October 04, 2007 3:17 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 29, 2013 3:37 PM
Points: 161, Visits: 48

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.

Post #407120

ChiragNS

Posted Friday, October 05, 2007 5:21 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

Hi

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

"Keep Trying"

Post #407282

Steve Jones - SSC Editor

Posted Friday, October 05, 2007 9:23 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 11:20 AM
Points: 31,437, Visits: 13,752

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

Post #407415

Rajni Kant Ranjan

Posted Monday, October 08, 2007 4:53 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:22 PM
Points: 156, Visits: 247

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

Post #407915

Suvendu

Posted Thursday, August 12, 2010 10:36 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 7:15 AM
Points: 6, Visits: 61

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.

Post #968647

« Prev Topic | Next Topic »

Permissions