odbc sql server does not exist or access denied

I just installed SQL 2005 on a backup/test server. When I connected with ODBC to the new server I lost all of my ODBC connections, even to the working server (SQL 2000). I did a full repair on XP and got the ODBC to connect. Why would connecting to SQL 2005 cause my ODBC to crash ?. I tried using SQL Native as well, with no joy to either server. My ODBC isn't working again. The problem began as being intermittent, i.e. connected one minute, lost connection the next. Now it's permanently disconnected and I'm not even sure the reinstall was a solution.

Take a look at - http://support.microsoft.com/kb/328306

Hope this helps

|||Also got the error from another machine "does not allow remote connections" when connecting to ODBC.

The fix was to ensure that SQL Server Surface Area Configuration (via Start / etc) , Remote Connections set to "Using both TCP/IP and named pipes" (which was already default in my instance), and instead of using the name of the server in the ODBC drop-down list, use the servier IP, i.e. 10.0.0.XXX.|||

Is your issue resolved? If so, please mark your question anwserred.

If you are able to connect using IP address, but not with machine name, most likely you have a DNS problem on your network.