I have two servers running SQL Server on the same network and I am
receiving errors registering the various instances as follows:
SERVER1 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
Connect()
SERVER1 trying to register Server2's default instance (by netname, ip
address and local) COMPLETES SUCESSFULLY (THIS INSTANCE CAN BE REGISTER
FROM ANYWHERE PROVIDED THAT YOU HAVE PERMISSION(S)
SERVER2 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: ssl security error -connectionopen(secdoclienthandshake)
SERVER2 trying to register Server1's default instance (by netname, ip
address and local)
ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
Connect()
Note: SERVER2's default instance was registered locally before, but I
wanted to change the alias name so I unregistered it and tried to
register it with the new alias. I only change the alias name not the
underlying information which was previously registered. That is when I
started to receive the errors. ALSO I DON'T KNOW IF THIS MATTERS, BUT
D01 WAS CLONED FROM D02 BECAUSE OF A DISK FAILURE. I DID HOWEVER RUN
THE NEWSID UTILITY.
Any Ideas?