SQL Server 2000 crashes when executing a Query

• StarGazerNC

  SSC Rookie

  Points: 37

  More actions

  August 13, 2003 at 8:03 am

  #64378

  Hello all! This is my first message here, and I need help. I am an experienced software developer and SQL language user (about 5 years), but now I'm also starting as a database administrator, and my firts task is taking care of a problem... The thing is that I'm geting my SQL Server 2000 to crash when I run some kind of process. It may be a simple query, or a complex one. The simple may fail and crash SQL Server and the complex not or vice-versa. In the Windows Event Log, it puts the following information (note thath where is "sa" could be some other user, the result is the same):

  "The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 18454; Login succeeded for user 'sa'. Connection: Non-Trusted."

  I'm currently browsing on Books On-Line to try and find something about this, but still I haven't found what I'm looking for...

  There are a SQL Server 7 and a SQL Server 2000 used by the same application.

  I've read some info and I didn't get any good ideas on how to solve this.

  Can anyone be kind enough to help me? Very apreciated!

  Stargazer

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 19, 2003 at 5:39 pm

  #470507

  If the service is actually dropping, I'd recommend a call to support. $250 well spent. Shouldnt be ANYTHING you can do that would drop the service. Have you looked at the dmp files it creates? Might give you a clue. Now would be a great time to make a good backup and make sure it's good, then run a DBCC to make sure your db's are good.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn