SQL Server 2005 Issue Help!

[MuttsNutts]

Server 2003 R2 SP2 32Bit

Two of my SQL services fail to start
SQL Server (SAGE200) & SQL Server Agent (Sage200)

SQL Server (SAGE200) fails with:
could not start the sql server (Sage200) service on local computer.
Error 1053: the service did not respond to the start or control request in a timely fashion

SQL Server Agent (Sage200) fails with:
could not start the sql agent (Sage200) service on local computer.
Error 1068: the dependancy service r group failed to start.

I've checked and theres no dependancies anyway I guess its refering to the SQL Server (SAGE200) service that needs tobe started first.

Also Unable to open SQL Server Configuration Manager.. getting the following error :

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Access denied.
[0x80041003]

I Have managed to get past that error but get this one now:
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Invalid Class.
[0x80041010]

I have done a detect and repair of windows WMI and done a full reinstall of it too.
So no luck
any help would be great thanks

 

[Pho]

Have a look at the ERRORLOG files in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG (might be different on your machine, but it'll be in the Microsoft SQL Server folder somewhere) and also check the event viewer for any other information.

 

[MuttsNutts]

Thanks have checked the logs and it points to a WMI issue as it needs this to connect.

I have researched this a lot today and found that reinstalling WMI on the server and re parsing the MOF files for WMI components & some of the SQL MOF files.

I came across some commands to run from different tech notes and decided to build a script to do the whole thing, it's below

@Echo on
cd /d c:\temp
if not exist %windir%\system32\wbem goto TryInstall
cd /d %windir%\system32\wbem
net stop winmgmt
winmgmt /kill
if exist Rep_bak rd Rep_bak /s /q
rename Repository Rep_bak
for %%i in (*.dll) do RegSvr32 -s %%i
for %%i in (*.exe) do call :FixSrv %%i
for %%i in (*.mof,*.mfl) do Mofcomp %%i
net start winmgmt
goto End

:FixSrv
if /I (%1) == (wbemcntl.exe) goto SkipSrv
if /I (%1) == (wbemtest.exe) goto SkipSrv
if /I (%1) == (mofcomp.exe) goto SkipSrv
%1 /RegServer

:SkipSrv
goto End

:TryInstall
if not exist wmicore.exe goto End
wmicore /s
net start winmgmt
:End


This can take some time to run upto 10 mins or so........

It's fixed some fo the issues I've been having but not all, so any other help would be great.....

Head Scratchingly painful this has been, Soon it will be time for me to call Bill aka Microsoft and finally use my Gold Partner Status support