Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Unanswered: 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 appreciated

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Re: Cannot Connect to SQL Server

    RE:
    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.}

  3. #3
    Join Date
    Jan 2003
    Posts
    2
    SQL Server is running. SQL Server Agent Locks Up when you try to start it.

  4. #4
    Join Date
    Oct 2002
    Posts
    369
    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.

  5. #5
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    Didn't you apply patch against Slammer on version prior to SP2?

  6. #6
    Join Date
    Jan 2003
    Posts
    6
    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

  7. #7
    Join Date
    Mar 2004
    Posts
    7
    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.

  8. #8
    Join Date
    Jan 2003
    Posts
    6
    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.

  9. #9
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  10. #10
    Join Date
    Mar 2004
    Posts
    7
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •