Albert Widjaja
asked on
SQL Server agent & maintenance task issue ?
Hi All,
I'm currently running SQL Server 2012 Standard SP1 on my Windows Server 2008 R2 and have login as SA user, somehow I cannot start the SQL Agent from SSMS and cannot edit the SQL maintenance job with this error:
Any help would be greatly appreciated.
Thanks,
I'm currently running SQL Server 2012 Standard SP1 on my Windows Server 2008 R2 and have login as SA user, somehow I cannot start the SQL Agent from SSMS and cannot edit the SQL maintenance job with this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
'Agent XPs' component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. (ObjectExplorer)
------------------------------
BUTTONS:
OK
------------------------------
Any help would be greatly appreciated.
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys, it seems the SQL Agent Service was stopped because of the service wa using Service account.
Not sure why, but when I change it as the local account it works again ?
Note: the service account is not locked.
Not sure why, but when I change it as the local account it works again ?
Note: the service account is not locked.
The agent account does require instance and database access (jobs are stored in msdb database). This is not the case for the SQL Server Service account.
Just to clarify.
Regards Marten
Just to clarify.
Regards Marten
Thanks guys, it seems the SQL Agent Service was stopped because of the service wa using Service account.Did you check if the SQL Agent account had permissions in SQL Server instance?
what to do? basically all info and action you need to know have been provided by the error message. :)