SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Service won't start on a blade
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

X002548
Not Just a Number

15586 Posts

Posted - 04/19/2005 :  15:46:42  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 04/19/2005 :  15:53:33  Show Profile  Reply with Quote
what hardware are you using?
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 04/19/2005 :  16:06:56  Show Profile  Reply with Quote
IBM's EMC....I'm outta my depth here...



Brett

8-)
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 04/19/2005 :  16:11:04  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 04/19/2005 :  16:11:17  Show Profile  Reply with Quote
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



Edited by - eyechart on 04/19/2005 16:11:58
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 04/19/2005 :  16:17:05  Show Profile  Reply with Quote
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 - 04/19/2005 :  16:55:45  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 04/19/2005 :  17:33:29  Show Profile  Reply with Quote
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 - 04/20/2005 :  09:37:21  Show Profile  Reply with Quote
Thanks.

I plan on rebuilding the entire box



Brett

8-)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000