SQL server Services are not getting start automat | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL server Services are not getting start automat

Hi all, When the server is restarted due to some reasons the sql server services are not starting automatically. I checked in the services whether it is manual or automatic but it is specified to automatic only. i did manual of sql services after that agent services are not getting start automatically. same in services it is specified to automatic only. any one can please help me why the services are not starting automatically Regards,
Mahi Mahi
Hi,<br />have refer SQL Error Log and windows Event viewer for more !? is their anything inside it ? are you updated with latest SP , Hot fixes and MDAC ? is your Service Agent user have proper privillege ?!<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
hi Mahi, as hemant said this maybe due to missing privilege, check whether the SQL Services use local system account or a specific account to start the service. Also if you use a specific username, check in your local security policy or if you have grp policy whether the account has log on as a service rights. hope this helps.
also please post the errors you have in Windows Event log AKTHAR
HI Mahi, In the Documentations, I have read somewhere that, if the Windows application log is full, even then the Agent services will now get start. Can you clean the log and try it? -Johnson
Maybe this is a silly question, but can you start the instance manually? <<I checked in the services whether it is manual or automatic but it is specified to automatic only>> Where did you check this? EM, OS services applet, T-SQL, Registry?
hi guys, i got it, it was my SQL Agent that requires a domain account to start Thanks
AKTHAR AKTHAR
Hi,<br />thankx for informing us that issue is resolved .<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Mahi
Have you resolved your issue from above counters. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>