Error "The SQL agent service is not running or its start-up type is not automatic on the computer [computername]. Start the service and set its start-up type as automatic to proceed.
search cancel

Error "The SQL agent service is not running or its start-up type is not automatic on the computer [computername]. Start the service and set its start-up type as automatic to proceed.

book

Article ID: 151909

calendar_today

Updated On:

Products

Control Compliance Suite Databases MS SQL SRVR Control Compliance Suite Unix Control Compliance Suite Databases Oracle Control Compliance Suite Netware Control Compliance Suite Exchange Control Compliance Suite Windows

Issue/Introduction



 

Resolution

The Microsoft SQL Agent Service must be set up as a local system account. If a domain account is used, then the account must be assigned to the sysadmin role for the Microsoft SQL Server. In addition, the account must be added to the group SQLServer2005SQLAgentUserComputerNameInstance Name.