SSISDB Project Deployment expired Certificates

John Couch 21 Reputation points
2024-05-31T04:00:21.25+00:00

We have hundreds of project deployment certificates that are expired, but I tried to find what is using them and am unable to. I tried dropping them, but it says they are in use. How do you figure out which project is using the certificates?

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,756 Reputation points
    2024-05-31T06:45:16.9833333+00:00

    Hi @John Couch,

    You may use below code to check the certificate.

    SELECT  *
FROM    sys.certificates

    All certificates have an expiry date, but for most uses of certificates in SQL Server, the expiry is not checked.

    If the certificates do not affect your business and do not show errors, you may ignore it.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.