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
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