Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1579
  • Last Modified:

SQL Server Critical Errors

I am receiving several MSSQLSERVER application errors most of which are event id: 17052,17055, and 19011. I have checked all permissions related to SQL and all are using the local system account. I have even uninstalled and reinstalled SQL server application and no difference was made. Every few hours the MSSQLSERVER service quits and I must restart it twice to get it to work and then I have to reconnect the 20+ workstations that access it. Can anyone give me some pointers as to the cause of the errors and possibly afix or test to run? Thank you.
0
GMSMRM
Asked:
GMSMRM
  • 8
  • 7
5 Solutions
 
James MurrellProduct SpecialistCommented:
You should list the detailed error message of event 17052,17055, and 19011 to identify the
possible causes.
0
 
GMSMRMAuthor Commented:
Sure. Here are the detailed messages I am receiving.

Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17052
Date:            6/10/2008
Time:            9:12:40 AM
User:            N/A
Computer:      GMS2K3
Description:
Error: 17825, Severity: 18, State: 4
Could not close Net-Library ''.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 000045a1 00000012 00000007 004d0047
0010: 00320053 0033004b 00000000 0000

-------------------------------------------------

Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17052
Date:            6/10/2008
Time:            9:12:40 AM
User:            N/A
Computer:      GMS2K3
Description:
Error: 17059, Severity: 18, State: 0
Operating system error 10038: An operation was attempted on something that is not a socket..

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: a3 42 00 00 12 00 00 00   £B......
0008: 07 00 00 00 47 00 4d 00   ....G.M.
0010: 53 00 32 00 4b 00 33 00   S.2.K.3.
0018: 00 00 00 00 00 00         ......  

--------------------------------------------------

Event Type:      Error
Event Source:      MSSQLServer
Event Category:      (8)
Event ID:      19011
Date:            6/10/2008
Time:            9:02:22 AM
User:            N/A
Computer:      GMS2K3
Description:
SuperSocket info: LoadNetlibs(Via) : Error 11.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

---------------------------------------------------

Event Type:      Error
Event Source:      MSSQLServer
Event Category:      (8)
Event ID:      19011
Date:            6/10/2008
Time:            9:02:22 AM
User:            N/A
Computer:      GMS2K3
Description:
SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
 
----------------------------------------------------

Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17055
Date:            6/10/2008
Time:            9:02:16 AM
User:            N/A
Computer:      GMS2K3
Description:
17113 :
initconfig: Error 32(The process cannot access the file because it is being used by another process.) opening 'D:\Microsoft SQL Server\MSSQL\data\master.mdf' for configuration information.


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: d9 42 00 00 10 00 00 00   ÙB......
0008: 07 00 00 00 47 00 4d 00   ....G.M.
0010: 53 00 32 00 4b 00 33 00   S.2.K.3.
0018: 00 00 00 00 00 00         ......  

---------------------------------------------------------

Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17055
Date:            6/9/2008
Time:            7:53:03 PM
User:            N/A
Computer:      GMS2K3
Description:
17310 :
SqlDumpExceptionHandler: Process 480 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 9e 43 00 00 10 00 00 00   žC......
0008: 07 00 00 00 47 00 4d 00   ....G.M.
0010: 53 00 32 00 4b 00 33 00   S.2.K.3.
0018: 00 00 00 00 00 00         ......  


Hope this helps.
0
 
Eugene ZCommented:
make sure you installed at least sp3a for sql server 2000 (it  sql server 2000 . Is it correct?)

Open windows event viewer and check system and applications log errors
Could be hardware related  problem (maybe you need more  RAM, etc)
also check CPU utilization - > maybe you will need to review sql server performances, review code, add indexes, etc
-------------------------------------------------------------------------------------

also review
FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3
http://support.microsoft.com/default.aspx?scid=kb;en-us;840856
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
GMSMRMAuthor Commented:
Yes. I am running SQL server 2000. I do have sp3a installed.

In the viewer I only have errors where the SQLSERVERAGENT tried to restarto but could not due to SQLSERVER not running. Other than that I am running Windows 2003 standard with 4GB ram and CPU utilization is running at most 30%.
0
 
Eugene ZCommented:
try to run perfmon to see what is going on with the box
also check sql server log..

did you check?:
FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3
http://support.microsoft.com/default.aspx?scid=kb;en-us;840856
0
 
Eugene ZCommented:
looks like you need to try sp4 or open case with Microsoft
But before:  try to set sql server properties (if you have not set yest):
 processor -> Boost Sql Server priority on Windows ..
0
 
GMSMRMAuthor Commented:
I spoke with our support for the suoftware that is using the datbase and he looked over all fo the data and settings and even took a copy of the data and ran it on their servers and everything checked out fine. From you expertise, do you think this is a performance or access issue?
0
 
GMSMRMAuthor Commented:
I will try to install sp4 again. Last time I installed it, there was no difference. I already have Boost Sql priority on.

FYI I posted my previous comment before receiving your latter post.
0
 
Eugene ZCommented:
performance hardware related
sometimes combination : small RAM and bad code (no indexes)...
0
 
Eugene ZCommented:
BTW: what do you have installed on the box additionally to Sql server?

--Did support check sql server settings ? memory setup, etc?
Do you have any slowness complains ? is  anything running before sqlserver service stopped?
0
 
GMSMRMAuthor Commented:
We are a small company and have just 1 server. This runs Active Directory, DNS, DHCP, App, FIle and print server. Supports about 30 workstatons. On SQL I have two systems running, one called Made 2 Manage, the other Unitime. Also we run Abra Suite but that is not on SQL.

Support did check memory setup, we adjusted the virtual memory to lower the number of handles. I am looking right now and I have 900454 handles and growing. 1215 Treads and 89 processes.

The large number of handels, is this program/index related or performance?
0
 
Eugene ZCommented:
It is not good  (all apps on same server: security; performs, etc- but what you can do about it)


did you check with hardware vendor support?
0
 
GMSMRMAuthor Commented:
Yes. I we are looking into purchasing an additional server. One last question. If the server is being overworked in any way, why does the CPU % not running at a higher %?
0
 
Eugene ZCommented:
if it does not - it is good- >check memory usage, etc - try perfmon counters
0
 
GMSMRMAuthor Commented:
Thank you for being so dilligent and easy to understand. I know it is difficult to decifer some of the windows event codes. I hope that load balancing to another server will do the trick.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now