SQL server CRASH, cant reconnect ODMC time out ..

• Digs

  SSCertifiable

  Points: 7333

  More actions

  March 5, 2006 at 7:39 pm

  #112000

  Hi

   

   

  My SQL server crashed.

   

  SQL server local is on my Desktop machine, not down a network

  OS: Windows server 2003

  RAM: 3MB

  CPU: 3GB

  HD: 140GB

  SQL server 2000

  Enterprise Manager, SQL query

   

   

  Now I cant even get Enterprise manager to connected to databases or MS Query to connect to LOCAL. I think because the query crashed on my 20GB table the ODBC is still hanging. ODBC fails due to timeout (Error : HYT00).

   

  What I have done.

  -         Shut down and restarted the machine.

   

  I am thinking a full un install SQL server 2000 and do a re install.

   

  Any way to fix the ODBC between SQL server tools and databases.

   

  Any ideas

   

  My MDAC file sqlsrv32.dll seams to be fine also, as I can link to other Sql servers, that are on other boxes.

   

  Below is ODBC error from SYSTEMDSN to sql server.

   

  

• Kishore.P

  SSCrazy Eights

  Points: 8147

  More actions

  March 5, 2006 at 10:55 pm

  #624809

  Just try the following command and check output:

  DBCC CHECKDB([<dbname>])

  and also check the rest of parameters in SQL BOL.

  

• Digs

  SSCertifiable

  Points: 7333

  More actions

  March 6, 2006 at 10:47 am

  #624970

  I cant log on to run any queries in SQL Query analyzer.

  I get time out of QA and EM, I cant connect to SQL full stop.

  Can I run SQL from the windows  command prompt is C:\...

   

• philcart

  SSC-Forever

  Points: 47797

  More actions

  March 6, 2006 at 2:35 pm

  #625049

  Check Windows Event log for any error messages.

  Check to see if the SQL Server service is running.

   

  --------------------
  Colt 45 - the original point and click interface