November 9, 2012 at 2:32 pm
I have 3 servers (principal, mirror, and witness) each of them as SQL Server installed and listening and nonstandard ports (1533 and 1633). When I go through the Configure Security Wizard I am able to select my servers and connect to them. After I finish the wizard and try to start mirroring, it spins for a while then gives me the following error
The server network address "TCP://mydomain.com:5222" 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)
This address happens to be my mirror. Now, I can ping all my servers, and each server's SQL Server process is listening on port 5222. For TCP addresses I have tried:
TCP://mydomain.com:5222
and
TCP://mydomain.com,1533:5222
***Of course, the value for mydomain.comin the ports changes for each server.
These servers are not within a domain, so I have left the service account text boxes empty. The principal server is the only one that is not running under the NT AUTHORITY\LOCAL SERVICE account.
I'm just wondering where I'm going wrong and how I can fix it. Any ideas?
November 11, 2012 at 10:11 am
Hi,
Please refer Parry comment. In work group environment required certificate to trust each server.
Satish
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply