sql server does not exist or access denied connectionOpen(connect())
I am trying to link SQL SE 2000 (Local server at head office) to MSDE 2000 (remote server). After creating the server group in local server, I try to register SQL server Computers (MSDE 2000) to place in it.
But I received this error message.
"SQL server registration failed because of the connect failure displayed below. Do you wish to Register anyway
SQL Server does not exist or access denied connectionOpen(Connect()).'"
I checked the setup for client and server utilities.
Client Utility is TCP/IP
Server Utility is Named pipe
Please, help me. I don't know what went wrong here.
SQL Server does not exist or access denied. connectionopen(Connect())
Hi,
I am getting the above error when I try to connect to a remote sql server.
I have tried to connect using Named Pipes. However, that did not solve the issue.
I have verified the username, password.....and they are correct.
I have also re-installed my sql server, even that did not solve the issue.
I could connect a couple of weeks back...this error started popping only a couple of weeks ago. I have not installed any new software, firewalls etc on my machine since then, neither have I installed any new service packs.
Can anyone help me out here please !!!!