May 8, 2003 at 6:35 pm
Hi there, starting today the sqlserveragent service fails to start. All it says is that it could not be started and no error is given. In the event viewer, there is an entry but all it says also is that sqlserveragent could not be started. Any ideas why this is happening? Thank you in advance.
May 8, 2003 at 7:01 pm
What type service account your Agent runs? Local system account or domain account? Did you remove BUILTIN\Administrators login from SQL Server?
Right click SQL Server Agent in EM --> Display Error Log. Do you see any error messages?
Edited by - Allen_Cui on 05/08/2003 7:02:56 PM
May 8, 2003 at 7:23 pm
Hi Allen, the service is run under a domain account. Its a sql server 7. The BUILTIN\Adminstrators has been removed by the previous DBA.
The Sql Agent error log says that it is not able to connect and that the agent would not start. Thats about it. Very suspicious!
Thanks for your help.
May 8, 2003 at 7:25 pm
This is the error I get when I try to start sql server agent:
"Could not start the SqlServerAgent on Local Computer.
The service did not return an error. This could an interanl Windows error or internal service error.
If the problem persists, contact your system administrator."
May 8, 2003 at 7:29 pm
Make sure this domain account is in your SQL Server logins with 'sa' right.
May 9, 2003 at 10:27 am
Hi Allen, the username is in the logins and has "System Administrator" role assigned to it. I am not sure how to give it 'sa' rights. Can you please tell me? Thank you.
Also, is it possible to only reinstall the sql server agent?
May 9, 2003 at 11:32 am
'sa' means 'System Administrator' here.
Is same account used for SQL Server service too? I would try to change service account to system account in SQL Server Agent property to see whether Agent can be started.For test purpose, you need add 'BUILTIN\Adminstrators' back to SQL Server with 'sa' right.
Has password changed to this user recently?
Edited by - Allen_Cui on 05/09/2003 11:35:05 AM
May 9, 2003 at 1:19 pm
Check with the network admin to see if the password that the sqlagent login uses expired
or was changed.
May 15, 2003 at 5:14 pm
I would also check to ensure that the domain account that SQL Server Agent is configured to start under has sufficient permissions to run as a service. (Your System Administrator may have removed the account from your local Administrators group recently, or otherwise restricted it's permissions on that machine.)
I'd also definitely ensure that the password for that domain account has not expired (as Racosta suggested) or been locked out due to an excess number of failed logins.
David R Buckingham, MCDBA,MCSA,MCP
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply