We are unable to start SQL server Agent and it fails with below error:
SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).
Checked that Service account to run agent is added in admin group on the server.
Checked that it is added as sysadmin with the security of sql server login:
The account used to run is a domain account which has sufficient privileges since sql server is using that account to run the same in production:
SQl server here is SQL server 2005 Enterprise edition
Adding @ Also when i tried to check status agent xp with
EXEC SP_CONFIGURE 'Agent XPs' it says run value 0.
So i tried running :
EXEC SP_CONFIGURE 'Agent XPs',1 GO RECONFIGURE with override
But no success and fails with below error:
Configuration option 'Agent XPs' changed from 1 to 1. Run the RECONFIGURE statement to install. Msg 5845, Level 16, State 1, Line 1 Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process.
But run value is still 0
Please suggest what could be done here?