Skip to main content

Posts

Showing posts from February, 2014

SQL Agent disabled / how to enable SQL agent

Dear Readers,

Today i found that SQL agent is disabled and i can active through the below process


First you can check first these points

Go to run type services.msc

Right click on the SQL Server Agent (MSSQLSERVER)


Then check in the properties your startup type might be disabled change it to automatic or manual and try again it will enable the start option

If the above process not workable then check this one

SQL Server blocked access to procedure 'dbo.sp_get_sqlagent_properties' of component 'Agent XPs' because this 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.




You need to run the following script under you SQL management Studio




1) Open the new query




2) Past the code

sp_configure 'show advanced options',1;

GO

RECO…