Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server does not exist or access denied

Status
Not open for further replies.

earme

Programmer
Jul 27, 2000
155
US
Hello all,

This is the error I'm receiving:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

It's a Win2000 Server machine running SQL server, attempting to be accessed by my asp app via a dsn. I'm not at the location of the server.
And here's what happened: This morning I needed to make a change to the database so I called someone at the location of the server and walked him through the changes (it was just changing maybe 2 values in a table). Before the changes everyone was able to access the database without problem, however after the changes everyone was receiving the above error.
I had this user go back to the server and see if SQL Server was running, it was, he was able to look at the tables through Enterprise Manager. I had him go to the 'ODBC Data Source Administrator' to test the dsn and it came back successful. So, the SQL server was running and the dsn was connecting fine. However the error persists.

Any suggestions?

Thank you,
Earme
 
D'oh, this problem wasn't caused by the changes to the database, it was caused by the files I had them update. One of the files has a function that takes care of opening the database connection. The connection string that I use here on my test server is different than the one that they use there. I hadn't updated that particular file for so long (at least 2 months) that I forgot about that. So, I changed it back to what it should be, sent it back to them and *poof* problem solved.
Now, I just have to remember this for next time ;-)

Earme
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top