Enable Linux SQL Server Agent

Short tip this time around. If you are running SQL Server on Linux and connect to it from a Windows system with Management Studio (SSMS), the SQL Agent will  be off. If you right click the Agent in SSMS try to get the properties of it, you will receive a lengthy  error with this included:
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.

All good and normal. So how do you turn SQL Agent on?

Open a query window and execute this script:
sp_configure 'show advanced options', 1;
sp_configure 'Agent XPs', 1;
FInally, right click on SQL Agent in SSMS and choose Refresh from the menu. You should now be able to access it.
SQL Server is a product of Microsoft Corporation.

Leave a Reply