Share via

SQL Server Agent SSISJobHistory also storing connection string and password in message

Nidhi Chawla 1 Reputation point
2020-11-05T14:34:06.877+00:00

Security concern has been raised and need to be fixed.

SQL Server Agent SSISJobHistory is also storing connection string and password in "message".

What can be done so that connection string is not logged in the message section of a MSDB.dbo.ssisJobHistory record

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,662 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,906 Reputation points
    2020-11-06T03:17:18.903+00:00

    Hi @Nidhi Chawla ,

    May I know if you can share the version of your SQL Server version ?

    May I know how do you set the logging in the sql server agent job?

    Best Regards,
    Mona

    ----------

    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.
    Hot issues in October--Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.