Sunday, February 19, 2012

Cannot Connect to SQL Server

I have been unable to connect since Sat to a SQL 2000 Server. Get the following error when trying to connect through Query Analyzer across the network:

Unable to connect to server
Server: Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General Network Error

In my Event Log I have the following error:

17310: process_loginread: Process 2548 genertaed ftal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Sevrer is terminating the process

When I try to connect through Query Analyzer locally, it locks up when I type in the sa password

Any help would be appreciatedRE:
I have been unable to connect since Sat to a SQL 2000 Server. Get the following error when trying to connect through Query Analyzer across the network:
Unable to connect to server
Server: Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General Network Error
When I try to connect through Query Analyzer locally (at the Server Console??) , it locks up when I type in the sa password

Q1 Any help would be appreciated

A1 Some things to consider and / or check may include:

Verify that the Sql Service is running. Is security (still) configured for the connection (sa = standard login) being attempted? Verify that the correct protocol, port, etc. is being accessed.

{More detailed information should make it easier for others to provide more useful / helpful feedback.}|||SQL Server is running. SQL Server Agent Locks Up when you try to start it.|||RE:
SQL Server is running.

Q2 SQL Server Agent Locks Up when you try to start it.

Some issues are apparently now resolved?

A2 Consider trying to:

Verify that the Sql Agent Service security context is configured with valid account information, or try using a local system account. Check the logs (incl. agent logs) for errors. Again, in general the more information available, the easier it is for others to provide helpful feedback.|||Didn't you apply patch against Slammer on version prior to SP2?|||Hi I'm learning SQL on the fly but I hope I might be able to help a bit, even if it's a little bit.
1. Are the computers talking? Can you see the other computer on the network?
2. Were any programs installed recently? It might've replaced a DLL that SQL Server might've needed to logon.
3. Are you sure about the SA password and user? If not, check the user and password.
4. What's the login mode? Might be a good idea to check it out.
5. Hard disk might be dued for final rites.

Good luck.

All the best,

Ka Kwok|||Originally posted by ispaleny
Didn't you apply patch against Slammer on version prior to SP2?

What did this virus do? I have the same problem.|||Originally posted by adrian320
What did this virus do? I have the same problem.

From memory it's a DOS attack. It makes a massive amount of requests to the server.
Regards,
Ka.|||http://www.microsoft.com/sql/techinfo/administration/2000/security/slammer.asp take help to combat the issue.|||Thank you for all the input,

I applied the hotfix for the virus to the 2000 sql servers we have running and they seem to work fine know.

Thanks.

No comments:

Post a Comment