Unanswered: Unable to connect to remote SQL Server DB
I am trying to remotely connect to a SQL Server 6.5 database and I am unable to do so. I can't create an ODBC connection or connect otherwise. I can connect when logged onto the server, but I cannot connect from a remote PC. There are no firewalls between the two machines and I have tried both IP address and hostname.
This is the error I keep getting:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
If you check the server properties, it should tell you . In 7 and 2k, you run the Server Network Utility. In 6.5, I believe it's in Enterprise Manager somewhere, but my memory is rusty as I havn't had to use 6.5 in years (thank god!).
You may also want to check the network library being used. If your client is trying to use TCP/IP, but the server is only listening on Named Pipes (or something similar) , that could be the problem as well.
On the server you use the server netowrk utility. Just make sure that TCP/IP is in the list of enabled protocols. The remote PC will need to use the client network utility or (if you're connecting through ODBC) the ODBC connection properties.