September 24, 2009 at 8:31 am
While mirroring setup I get following error:
An error occurred while starting mirroring.
Alter failed for Database 'AdventureWorks'. (Microsoft.SqlServer.Smo)
The server network address "TCP://LuckyPC.American.Ccp.microsoft.com:6677" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
How to troubleshoot this issue? How to verify whether this port is free or not?
Infact For mirroring setup I am using two instances on one m\c. Is this required to have two different m\cs?
-Lk
September 24, 2009 at 9:46 am
There is following information from the sql server profiler:
2009-09-24 21:10:10.87 Logon Database Mirroring login attempt failed with error: 'Connection handshake failed. There is no compatible encryption algorithm. State 22.'. [CLIENT: 172.12.138.108]
Perhaps this shows that I don't have correct logins. I shall create same sysadmin in both the servers and then try again.
But I am using windows login in both the instances. I am using both of these instances on one m\c. So this error is unlikely because of same sysadmin login in the master DB of both the instances.
-lk
September 24, 2009 at 10:11 am
There is some information on following link
http://archive.networknewz.com/networknewz-10-20080721SQLServerUpgradeDatabaseMirroringIssues.html
This looks relevant but should I need to reinstall the sql server as the auther of this article did :(?
How to completely drop previous mirroring?
-Lk
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply