-
SQLServerAgent and MSSQLserver dependancy issue :confused:
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.
-
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.
-
You can fix it by modifying registry.
-
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
-
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 .
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|