Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 odbc error

Author  Topic 

joemama
Posting Yak Master

113 Posts

Posted - 2008-08-20 : 15:10:38
all of a sudden I am getting this error (this app has worked for over a year and a half with no problems before today)..nothing in the app or the database has changed

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

when I try to make the odbc connection from the app server (windows)it fails...however when I make it from my desktop it is ok

any clues?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-20 : 15:32:43
You've run into a connectivity issue.

See my blog on how to troubleshoot it:
http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -