SSISDB Project Deployment expired Certificates

John Couch 21 Reputation points

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,487 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points

    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.


    Zoe Hui

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