May 2, 2009 at 3:41 pm
SQL server, SQL server agent is not restating after server reboot though it is set to automatic mode.
Also in some other server I found that after some security patch upgradation the SQL server mode is being changed from Mixed to Windows.
Any Idea?
Thanks,
Jeet
May 2, 2009 at 4:35 pm
Hi Jeet,
Please check the ERRORLOG file for the SQL server to see what is the reason for not starting up. Please paste that copy of the error log here for further help.
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
May 3, 2009 at 5:24 am
Hello,
Hopefully there will be some useful messages in the Event Log which will help identify the issue.
As the SQL Server was previously working though, my first guess would be a problem with the Account under which the Services run e.g. the Password has been changed or the Account is locked out.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
May 4, 2009 at 3:56 am
agreed with marsh.
seems permission related issue. please check for permission for the account from which you are running.
Manoj
May 4, 2009 at 10:57 pm
Dear,
Check the logon account , password for the services. Re-enter the password and try starting the services.
Cheers,
- Win
"Dont Judge a Book by its Cover"
May 4, 2009 at 11:03 pm
With above, also check that if your service is dependent on any other service; and if yes, then check run mode for that parent service.
"Don't limit your challenges, challenge your limits"
May 5, 2009 at 3:14 am
Yes, permission for the account that is running the SQL service and permission in the bin program files folder of the SQL server, where the executable is placed.
May 6, 2009 at 11:17 am
THis happens to me all the time. We have our SQL accounts set to log on as a service in AD, but after a reboot I often have to go to MSSQLSERVER under services in control panel and enter in the password again for the service account and then start the service. This works until the next reboot.
These accounts are domain users, and members of the Administrative group on the server, as well as members of the sysadmin role in SQL Server.
May 7, 2009 at 1:53 am
If you have a user from other domain you could check trust between domains.
May 8, 2009 at 10:14 am
We also are experiencing the Agent not starting inconsistently over 24 servers. I do see a timeout message, but this is fairly recent.
When I manually start the Agent, it will fail to start on the first attempt then start right up on the next attempt.
May 8, 2009 at 12:22 pm
The sql agent service account is a member of the local administrators group on each server?
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply