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

Mirroring failed due to invalid connection string Expand / Collapse
Author
Message
Posted Friday, March 1, 2013 1:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 10:55 AM
Points: 18, Visits: 135
Hello,
I'm receiving the following error:

ALTER DATABASE command failed due to an invalid server connection string.

when I issue the command:

ALTER DATABASE DBName SET PARTNER = 'TCP://DCDRSQLv01.datacoremarketing.com\SQLMICH01:5022';
GO

Situation - I'm attempting to mirror from a default instance to a named instance. Each instance is running SQL 2012 SP1. Each server is in a different domain and I have configured logins and certificates to make it work properly. I've seen several posts indicating try the following:

- check that both servers can be pinged, name resolves and telnet succeeds to the configured port 5022.
- confirm that mirroring is started and logins are granted permission.
- restore database and transaction log with NORECOVERY option.
- Confirm the database and instance are correct.
- Attempt connection without the instance name.
- Start the Browser service on all nodes.

None of these appear to be providing a different result except for the later which complains "network address cannot be reached" (note telnet to 5022 does work).

Any assistance is most appreciated. I'm out of ideas.

Post #1425386
Posted Tuesday, March 5, 2013 1:52 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, July 11, 2014 10:53 AM
Points: 942, Visits: 1,061
In the database mirroring endpoints do not specify the instance name. Should be http://servername.fqdn:port.


---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.


How to ask for help .. Read Best Practices here.
Post #1427034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse