Monday, December 22, 2008

solved problem: New SQL Server Registration failed: server does not exist or access denied. ConnectionOpen(Connect())

After downgrade of SQL server due to speed problems both on local and remote production server, I can't re-register the remote production server in enterprise manager on local machine.

After many research and googling, registration on the other way/side is successfull but all resolutions on local failed.

Solution:
Remove Server Alias of remote server from local Client Network Utility. This alias makes the remote server name as local that's why it can't connect.

No comments: