SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Won''t Start


SQL Server Won''t Start

Author
Message
Brian Brant
Brian Brant
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 3
We're having a problem with one of our database servers. The problem is we can't get SQL Server to start. I looked at the services and the MSSQLSERVICE says "starting" but it never actually starts.

I'm thinking this is a Windows (2000) or hardware issue and not specifically SQL Server 2K itself. I say this because we have at least one other application that has a "hung" service. Likewise, after we login to the server, it takes a good 5-10 min for the desktop to load.

Does anyone have an idea on what could be happening or what can be done to fix? I reviewed a couple SQL log files and found some of these items.

From ERRORLOG.1
2005-08-30 10:10:57.32 server LogEvent: Failed to report the current
event. Operating system error = 31(A device attached to the system is not
functioning.).
2005-08-30 10:10:57.57 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b

=========================================

From ERRORLOG.2
2005-08-30 07:48:57.80 server LogEvent: Failed to report the current
event. Operating system error = 31(A device attached to the system is not
functioning.).

===================================================

From ERRORLOG.3
2005-08-30 07:34:03.21 server LogEvent: Failed to report the current
event. Operating system error = 31(A device attached to the system is not
functioning.).
2005-08-30 07:34:03.45 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2005-08-30 07:34:03.88 spid3 Starting up database 'master'.
2005-08-30 07:34:05.31 server Using 'SSNETLIB.DLL' version '8.0.311'.
2005-08-30 07:34:05.31 spid5 Starting up database 'model'.
2005-08-30 07:34:05.38 spid3 Server name is 'OurServerName'.
2005-08-30 07:34:05.38 spid8 Starting up database 'msdb'.
2005-08-30 07:34:05.38 spid9 Starting up database 'pubs'.
2005-08-30 07:34:05.38 spid10 Starting up database 'Northwind'.
2005-08-30 07:34:05.38 server Error: 17826, Severity: 18, State: 3
2005-08-30 07:34:05.38 server Could not set up Net-Library 'SSNETLIB'..
2005-08-30 07:34:05.38 server Error: 17059, Severity: 18, State: 0
2005-08-30 07:34:05.38 server Operating system error -1073723998: ..
2005-08-30 07:34:05.40 spid11 Starting up database 'OurDatabase'.
2005-08-30 07:34:05.38 server Unable to load any netlibs.
2005-08-30 07:34:05.46 server SQL Server could not spawn FRunCM thread.

=========================================

From SQLAGENT.OUT
2005-08-30 06:30:20 - ? [130] SQLSERVERAGENT stopping because of Windows
shutdown...
2005-08-30 06:30:23 - ! [298] SQLServer Error: 913, Could not find database
ID 8. Database may not be activated yet or may be in transition. [SQLSTATE
42000] (ConnExecuteCachableOp)
2005-08-30 06:30:23 - ! [298] SQLServer Error: 913, Could not find database
ID 8. Database may not be activated yet or may be in transition. [SQLSTATE
42000] (ConnExecuteCachableOp)
2005-08-30 06:30:27 - ! [359] The local host server is not running
2005-08-30 06:30:28 - ? [098] SQLServerAgent terminated (normally)

Any help or advice is greatly appreciated!

Thanks,
Brian
dharper3
dharper3
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2101 Visits: 5

Hi , yeh I have seen this, and pretty weird. Solution in my case was to reboot server and all has worked fine since. Problem originally occurred after I tried to move MSDB database all was fine prior. Reboot fixed.

Derek





sswords
sswords
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6792 Visits: 84

The 'A device attached to the system is not functioning' message bothers me. This is usually indicative of a corrupt dll or driver or you may have a disk drive or controller that's failing. I'd advise you to review the server event logs and see if you're getting any indications of where exactly the failure is occuring. This should show up at system startup. Of course if the disk were failing, it could also lead to corrupt dll's, drivers, and data files compounding the problem.



My hovercraft is full of eels.
SQLBill
SQLBill
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41864 Visits: 1093

Run this via Query Analyzer:

SELECT ServerProperty('ProductVersion'),
ServerProperty('ProductLevel')

I'll bet it will return 8.00.311 and SP1.

I suggest you download and install SP3a for SQL Server. That might help solve your problem. (SQL Server is now up to SP4, but I would only apply SP3a at this time). Once you get everything working, then look into applying SP4.

-SQLBill





Brian Brant
Brian Brant
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 3

SQLBill -

Thanks for the reply. I did as you said and here's what returns:

8.00.194 RTM

I thought SP3a was applied for SQL Server. However, a rather unreliable vendor did this for us and it's possible it may not be installed correctly. Is there any way I can verify?

I did an @@version and the following was returned:

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 5.0 (Build 2195: Service Pack 4)

Thanks,
Brian


Brian Brant
Brian Brant
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 3

sswords -

Our server group has been reviewing the logs and they're not seeing anything out of the ordinary.

They tried to kill the MSSQLSERVER process but couldn't until DTC was disabled. Not sure what this has to do with it but as long as DTC is disabled, they can kill and successfully restart the service. Certainly not a perm. fix but it is one thing that was discovered so far.

We did a dbcc check and the database looks good from that aspect (i.e. everything is there an doesn't show signs of corruption). Just a bit frustrating because nothing is really jumping out indicating what the issue is such as errors in the database and/or server logs or event viewer.

Thanks for your post.

Brian


SQLBill
SQLBill
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41864 Visits: 1093

194 RTM means there aren't ANY service packs applied.

Download SP3a from Microsoft's website, read the install directions and apply it. You will have to give the SA account a strong password if it doesn't have one already.

-SQLBill





Brian Brant
Brian Brant
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 3

I applied sp3a. Unfortunately the same problem still exists - after logging on to the server the desktop is slow to load and when it does SS2K is still hung and the MSSQLSERVER service cannot be stopped and won't start.

One thing we did find is that if the sqlservr.exe and sqlmangr.exe processes are killed and you wait about 5 minutes it is then possible to manually get the MSSQLSERVER service (and the SQLSERVERAGENT service for that matter) to start. So we're not totally out of the water, just not running as we should.

If anyone has experienced a situation like this, any advices or suggestions on what could be the problem are greatly appreciated.

Thanks,
Brian


SQLBill
SQLBill
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41864 Visits: 1093

Do you have a strong password on the SA account? (Installing SP3a should have required this). I suggest running an updated antivirus on your system; since you had an unprotected (no service pack) SQL Server install you were 'open' to the SLAMMER worm and may have gotten infected. Not definitely, but it is a possibility.

-SQLBill





Brian Brant
Brian Brant
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 3

Yes. Definately had a stong password for the SA account prior to the issue we're experiencing. We have anti-virus software with the latest definitions installed on this server (this was installed & maintained when the server before the server went live a couple of years ago).

The only software we installed after the issue surfaced was anti-spyware although running it has turned up nothing. From a virus/spyware standpoint, we should be pretty clean which is good but it makes the troubleshooting even more frustrating.

Thanks,
Brian


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search