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 startI getquote: Error: 17883, Severity: 1, State: 02005-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 welcomeBrett8-) |
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-04-19 : 15:53:33
|
what hardware are you using? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-19 : 16:06:56
|
IBM's EMC....I'm outta my depth here...Brett8-) |
|
|
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 |
|
|
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/815056http://support.microsoft.com/kb/816840http://support.microsoft.com/kb/867878http://support.microsoft.com/kb/888444http://support.microsoft.com/kb/890637http://support.microsoft.com/kb/891268Some 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 |
|
|
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....Brett8-) |
|
|
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 WORKEDI 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 thingsI still can't beleive it....I think a rebuild might be a good idea...Brett8-) |
|
|
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 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-20 : 09:37:21
|
Thanks.I plan on rebuilding the entire boxBrett8-) |
|
|
|