Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Service won't start on a blade

Author  Topic 

X002548
Not Just a Number

15586 Posts

Posted - 2005-04-19 : 15:46:42
Ever since the started moving the servers over to "virtual" serves on blades, I been seeing weird problems.

No I can't get one to start

I get

quote:

Error: 17883, Severity: 1, State: 0
2005-04-16 21:49:05.37 server The Scheduler 0 appears to be hung. SPID 1, ECID 0, UMS Context 0x02554E88.



And a dialog error 1053 saying SQL Server Service could not be started in a timely manner.

ANY ideas are welcome



Brett

8-)

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-04-19 : 15:53:33
what hardware are you using?
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-04-19 : 16:06:56
IBM's EMC....I'm outta my depth here...



Brett

8-)
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-04-19 : 16:11:04
Maybe it is attempting to start before the network card is activated, and it fails because it can't reach a domain controller to login the SQL Server Service account.


CODO ERGO SUM
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-04-19 : 16:11:17
I suppose you googled the 17883 error and found all the technet articles on it. Looks like many issues have been fixed if you have applied the ms03-031 security hotfix.

Quick search shows these articles:
http://support.microsoft.com/kb/815056
http://support.microsoft.com/kb/816840
http://support.microsoft.com/kb/867878
http://support.microsoft.com/kb/888444
http://support.microsoft.com/kb/890637
http://support.microsoft.com/kb/891268

Some aren't in that hotfix though, so you might have to call microsoft or download it from the premier website (if you have an account).



-ec


Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-04-19 : 16:17:05
This is the default instance...I have a named instance running...go figure....

Brett

8-)
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-04-19 : 16:55:45
My Director decide to sms into the box, copy the sqlservr.exe from the named instance that is running, and copied it to the default instance.

AND IT WORKED

I told him he was dangerous...


I also forgot to mention that the box to hit when the machine rooms power got hit and the box went dead...you would think the have UPS's on these things

I still can't beleive it....

I think a rebuild might be a good idea...



Brett

8-)
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-04-19 : 17:33:29
did you apply sp3a and ms03-031 to both instances? It sounds like maybe one instance was patched up higher than the other. Copying the sqlsrv executable over another one is definitely dangerous, especially if the other files that go along with it are not at the same level. If one file is out of date or corrupted, then there could be more.

I would doublecheck that instance to make sure that it is patched up properly.


-ec

Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-04-20 : 09:37:21
Thanks.

I plan on rebuilding the entire box



Brett

8-)
Go to Top of Page
   

- Advertisement -