I have a member server in a Win2003 domain. The OS is Win2008 R2 Fdn with MSSQL 2005 Std installed. I use the domain administrator account to logon to the computer.
I have been unsuccessful at starting the SQLServerAgent service on the computer.
All other SQLServer services run without problem. Logon to all these services is via Windows authentication, using the domain administrator account.
When starting the SQLServerAgent from Management Studio, the error message is
"The SQLServerAgent service on ... started and then stopped.."
I also noticed the remark in parenthesis, "Agent XPs disabled" - what does that mean?
The event log shows reason as : "SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role" Error ID 103.
I checked and can confirm that the domain administrator account has been included in the sysadmin role. So why Unknown?
I tried to start the service from the services MMC, and also changed the logon to Local System account. I also tried to start from the command prompt with -c parameter. But all without success.
Would be grateful if an expert can help me out on this one. Thanks