Adding SQL Server Agent to Linux

With the release of SQL Server vNext CTP 1.4 you can now add the SQL Server Agent using the following on Ubuntu:
 

sudo apt-get update 
sudo apt-get install mssql-server-agent
sudo systemctl restart mssql-server

 
Interestingly once installed, the SQL Server Agent refused to start, even after a restart and the latest SSMS showed the SQL Server Agent as inaccessible.
 
image1
Running the below allowed me to access the SQL Server Agent in SSMS but the Agent still doesn’t start.

sp_configure 'show advanced options','1'
RECONFIGURE
GO
sp_configure 'Agent XPs','1'
RECONFIGURE
GO
sp_configure 'show advanced options','0'
RECONFIGURE
GO

 
Update: Not having much luck I suspected the issue may be that the server name was more than 15 characters. This is currently a reported issue by Microsoft. Starting over, I created a new VM called vnextvm and the agent installed and started this time with no issues.
 
image2

Leave a Reply