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 Mirroring Error Expand / Collapse
Author
Message
Posted Thursday, October 4, 2007 3:17 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 2:20 PM
Points: 161, Visits: 51
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
Posted Friday, October 5, 2007 5:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
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
Posted Friday, October 5, 2007 9:23 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:13 PM
Points: 33,100, Visits: 15,210
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
Posted Monday, October 8, 2007 4:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:21 AM
Points: 156, Visits: 377
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
Posted Thursday, August 12, 2010 10:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 30, 2013 2:10 AM
Points: 6, Visits: 63
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
Posted Tuesday, June 4, 2013 1:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 4:02 AM
Points: 1, 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.
Post #1459570
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse