SQL Server 2019 Linux: SQLServerAgent fails to run

Question

I am trying to execute a SQL Server Agent job on a SQL Server 2019 Standard on Linux.
Unfortunately, the SQL Server Agent terminates after it starts (see attached log).

My machine private IP is 172.31.112.69, while the SQL Server Agent startup service account is ip-172-31-112-6\ip-172-31-112-6$.
The error I get is: SQL Server does not accept the connection (error: 11001). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start.

Is there a way to change the SQL Server Agent service account to look for the new Private IP of the machine?
What suggestions would you have to solve this issue?

I would greatly appreciate any suggestions.

Best regards,
Daniel Ilie.

25805-sqlserveragent.txt

Answer 1

Hi @ILIE, Daniel ,

I first suggest you to check this similar cases:
https://github.com/microsoft/mssql-docker/issues/503

https://learn.microsoft.com/en-us/answers/questions/96464/mssql2019-for-linux-the-sqlserveragent-is-not-curr-1.html

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.