Solved

SQL Server process ends event id 19011

Posted on 2004-08-11
21
6,894 Views
Last Modified: 2008-01-09
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
Comment
Question by:tts-winchester
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
  • 4
  • +2
21 Comments
 
LVL 18

Expert Comment

by:SjoerdVerweij
ID: 11777938
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
 
LVL 34

Expert Comment

by:arbert
ID: 11778091
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
 
LVL 7

Expert Comment

by:FDzjuba
ID: 11778553
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
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 

Author Comment

by:tts-winchester
ID: 11778566
Not sure about SP3a - where do I check this?  Virus free according to Norton.  CPU utilization at 90% belongs to sqlserver
0
 
LVL 34

Expert Comment

by:arbert
ID: 11778582
select @@version   from query analyzer.....

You can also run SQL Profiler to see what sql server is actually doing at the time....
0
 

Author Comment

by:tts-winchester
ID: 11778750
select @@version:

Microsoft SQL Server - 8.00.760 (Intel X86)
0
 
LVL 7

Expert Comment

by:FDzjuba
ID: 11778834
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
 
LVL 18

Expert Comment

by:SjoerdVerweij
ID: 11778873
760 is not the latest version (818 is). Install Service Pack 3a.
0
 
LVL 34

Accepted Solution

by:
arbert earned 250 total points
ID: 11778965
Yes, without SP3a you're not protected against slammer--there is still a chance you could have it.
0
 
LVL 18

Expert Comment

by:SjoerdVerweij
ID: 11780451
By the way, FD: If that dump came from your production system........ I feel for you.
0
 
LVL 34

Expert Comment

by:arbert
ID: 11780479
What's run with the RTM version of SQL running on Windows NT???? :)
0
 
LVL 18

Expert Comment

by:SjoerdVerweij
ID: 11780567
Brett: that's asking what's wrong with running a Yugo on Everclear  :-)
0
 

Expert Comment

by:Mike Reynolds
ID: 11941011
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
 
LVL 34

Expert Comment

by:arbert
ID: 11948572
"Brett: that's asking what's wrong with running a Yugo on Everclear  :-)"


Dang, I bet that Yugo would FLY
0
 

Author Comment

by:tts-winchester
ID: 11952219
I've installed SP3, but "select @@version" doesn't give any different response.  Where do I procedures for MDAD 2.8 reinstall?  
0
 
LVL 18

Expert Comment

by:SjoerdVerweij
ID: 11954012
"Dang, I bet that Yugo would FLY"

Probably, but not in a straight line.

tts: www.microsoft.com/data
0
 

Author Comment

by:tts-winchester
ID: 11957167
MDAC 2.8 installed.  Reapplied SP3 with same results from select @@version.  Other ideas?
0
 
LVL 18

Assisted Solution

by:SjoerdVerweij
SjoerdVerweij earned 250 total points
ID: 11957395
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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
efficient backup report for SQL Server 13 80
SQL Lag Function DateDiff 2 26
Need more granular date groupings 4 45
SSIS Package Not Running in Batch File 3 10
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question