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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC / Query analyzer error

Status
Not open for further replies.

howardnl

Programmer
Apr 12, 2001
18
0
0
US
Hello,

I have a SQL Server database setup at a remote location and I have an ODBC connection to the server. I also use Query Analyzer to query the db. They both worked fine until the other day when I was fooling around with the local users on the remote server. Now when I try to access the db through Query Analyzer I get this:

Unable to server xxx.xxx.xxx.xxx:
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

And when I try to modify the ODBC connection I get this error when it is trying to access the server:

Connection failed:
SQLState: '01000'
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Does anyone have any ideas? I don't think I changed anything, except for adding a new user. I'm using SQL Server authentication.

Thank you very much for any help.

Thanks,
Nick
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top