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.
| Author |
Topic |
|
nickfinity
Yak Posting Veteran
55 Posts |
 Posted - 2002-01-03 : 10:11:24
|
| 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 connect 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 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-03 : 11:01:14
|
| HiYou didn't change any passwords on the SQL Server did you ? I had this problem just yesterday with a SQL Server some of my stuff is hosted on.The person that installed the SQL Server set it to run as his NT account. Then, months later he changed his password. Some time after that, they needed to reboot the server. After that, the SQL Server service wouldn't start.From memory, the resulting message when you try to connect is very like what you are getting.Go to "Services" in windows and see if SQL Server is running.I may be off base here, but worth a try.Damian |
 |
|
|
nickfinity
Yak Posting Veteran
55 Posts |
Posted - 2002-01-03 : 11:29:20
|
| Thanks for the reply Damian.SQL Server is running. I have an asp site that is hooked up to it that hasn't had any trouble. I think your thinking is along the right lines though. I did change the administrator password, but I thought I changed SQL Server to use the new password. I guess I'll have to make sure that everything is correct. Do you know of a way to be sure that SQL Server is using a good account?Thanks again for your help.Thanks,Nick |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-01-03 : 14:52:14
|
| Nick,In the Services window of your server, go to Properties on the MSSQLServer service. That will tell you what login the service is using. On our servers we have a dedicated machine login (NOT domain login). That way the SQL Server does not have rights to anything else on our network.--------------------------------------------------------------1000 Posts, Here I come! I wonder what my new title will be... |
|
|
|
|
|
|
|
|
ODBC / Query analyzer error