March 1, 2013 at 1:07 am
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.
March 5, 2013 at 1:52 pm
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[/url].
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. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply