• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7049
  • Last Modified:

SQL Server process ends event id 19011

I have a PC I'm working on that will be chugging away on a SQL project, and all of a sudden stop.  I'll be watching the performance meter in the upper 90% range, then boom, it drops to the floor.  Event viewer logs "Warning SuperSocket Info: (SPNRegister): Error 1355.  This equates to an Event ID 19011

Quick research seems to indicate it might be a rights related issue, but not sure.  Anyone have suggestions?
0
tts-winchester
Asked:
tts-winchester
  • 6
  • 5
  • 4
  • +2
2 Solutions
 
SjoerdVerweijCommented:
http://support.microsoft.com/?kbid=303411
http://support.microsoft.com/default.aspx?kbid=319723

This message is, however, just a warning -- and very unlikely to be the reason the server died. Anything else in the logs? At all?
0
 
arbertCommented:
Agree with SjoerdVerweij--this wouldn't be the cause of your problem.  Do you have SP3a installed?  Have you made sure you don't have a virus on this machine?  Whtn the CPU hits 90%, what's the process that's using the most cpu?
0
 
FDzjubaCommented:
Warning SuperSocket Info: (SPNRegister): Error 1355.  This equates to an Event ID 19011

"The error message you're getting is telling you that the SQL Server service isn't running as LocalSystem or as a domain administrator, so SQL Server can't register a Kerberos-related Service Principal Name (SPN) in your Active Directory (AD) domain. This error message is expected in your situation, so you can safely ignore it."


this is not the problem dig a bit deeper
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
tts-winchesterAuthor Commented:
Not sure about SP3a - where do I check this?  Virus free according to Norton.  CPU utilization at 90% belongs to sqlserver
0
 
arbertCommented:
select @@version   from query analyzer.....

You can also run SQL Profiler to see what sql server is actually doing at the time....
0
 
tts-winchesterAuthor Commented:
select @@version:

Microsoft SQL Server - 8.00.760 (Intel X86)
0
 
FDzjubaCommented:
get the full info, not a little bit of it

for example:

Microsoft SQL Server  2000 - 8.00.194 (Intel X86)   Aug  6 2000 00:57:48   Copyright (c) 1988-2000 Microsoft Corporation  Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)


>>>(Build 1381: Service Pack 6)

0
 
SjoerdVerweijCommented:
760 is not the latest version (818 is). Install Service Pack 3a.
0
 
arbertCommented:
Yes, without SP3a you're not protected against slammer--there is still a chance you could have it.
0
 
SjoerdVerweijCommented:
By the way, FD: If that dump came from your production system........ I feel for you.
0
 
arbertCommented:
What's run with the RTM version of SQL running on Windows NT???? :)
0
 
SjoerdVerweijCommented:
Brett: that's asking what's wrong with running a Yugo on Everclear  :-)
0
 
Mike ReynoldsSenior Systems and Scheduling ConsultantCommented:
Try installing MDAC 2.8 and then reinstalling Service Pack 3a.

I had a very similar problem and I could not even install SP3a.
0
 
arbertCommented:
"Brett: that's asking what's wrong with running a Yugo on Everclear  :-)"


Dang, I bet that Yugo would FLY
0
 
tts-winchesterAuthor Commented:
I've installed SP3, but "select @@version" doesn't give any different response.  Where do I procedures for MDAD 2.8 reinstall?  
0
 
SjoerdVerweijCommented:
"Dang, I bet that Yugo would FLY"

Probably, but not in a straight line.

tts: www.microsoft.com/data
0
 
tts-winchesterAuthor Commented:
MDAC 2.8 installed.  Reapplied SP3 with same results from select @@version.  Other ideas?
0
 
SjoerdVerweijCommented:
In that case, it's probably not SP3. You'll have to see what the server is doing right before it dies. Try running Profiler.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 6
  • 5
  • 4
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now