July 2, 2007 at 2:50 am
Good Morning
One of our servers has encountered a problem in that SQLSERVER Agent is no longer showing as a dependency of MSSQLSERVER when viewing the properties of the Service.
However, SQLSERVER Agent is showing that it depends on MSSQLSERVER when viewing the properties of the Service.
How do I correct this, as, at present, when we restart MSSQLSERVER, we need to manually start SQLSERVER Agent
Thanks
July 2, 2007 at 3:08 am
You can edit the registry key for the SQLAgent and MSSQLSErver to make then depends but be careful when editing registry keys.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 6:45 am
Do you know which keys?
July 2, 2007 at 7:02 am
HKLM\system\currentcontrolset\services and check for MSSQLServer and SQLServerAgent paths and you will find the details within those keys.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 7:58 am
The services are setup correctly. SQL Server Agent is not a dependency of MSSQLSERVER, meaning that the SQL Server Agent does not have to be running for SQL Server to run.
July 2, 2007 at 10:59 pm
Michael,
He says that his SQLAgent services does not show that it depends on MSSQLSERVER service. Actually what he says is right SQLAgent depends on MSSQLServer services but MSSQLServer does not depends on SQAGent as what you say.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply