SQL Server 2019 Linux: SQLServerAgent fails to run

ILIE, Daniel 21 Reputation points
2020-09-18T21:26:25.27+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,572 questions
{count} votes

Accepted answer
  1. Cris Zhan-MSFT 6,561 Reputation points
    2020-09-21T01:31:45.123+00:00

    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.


0 additional answers

Sort by: Most helpful