SQLServerAgent and MSSQLserver dependancy issue :confused:

[amarjun]

Hi All,

I have a problem where my MSSQLServer service is dependant on SQLServeragent service which should be the other way round.

I dont know the cause of it and how to resolve it. I have been researching around on it but couldnt find a solution. Can any one help me with this please.

thanks in Advance,

MK.

[skhanal]

Did you try going to Advanced tab of SQL Agent properties in Enterprise Manager and unchecking both auto start options. You can change it back afterwards.

[rmiao]

You can fix it by modifying registry.

[amarjun]

Hi All,

Thank you for your suggestions.

Can you suggest me on what keys that I should modify in registry?
Do you think there is any specific reason for the services to be like that?

I had come across the registry option over the net but I thought there might be a straight way to do it through the application.

I will try the unchecking and checking options to night.

thanks,

MK

[rmiao]

In hklm\system\currentcontrolset\services\sqlserverag ent, there should have keys DependOnGroup (reg_multi_sz type with no value) and DdependOnService (reg_multi_sz type and value is mssqlserver). And remove them from hklm\system\currentcontrolset\services\mssqlserver .