asked on

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.

James Murrell

You should list the detailed error message of event 17052,17055, and 19011 to identify the
possible causes.

Dennis Janson

ASKER

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.

EugeneZ

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

Dennis Janson

ASKER

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%.

EugeneZ

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

SOLUTION

EugeneZ

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Dennis Janson

ASKER

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?

Dennis Janson

ASKER

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.

SOLUTION

EugeneZ

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

EugeneZ

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?

Dennis Janson

ASKER

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?

ASKER CERTIFIED SOLUTION

EugeneZ

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Dennis Janson

ASKER

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 %?

SOLUTION

EugeneZ

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

EugeneZ

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Dennis Janson

ASKER

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.