where to check SQL Server Service Broker Certificate

Boopathi S 3,851 Reputation points
2025-09-21T11:00:49.2966667+00:00

Hello,

Where can i find the SQL Server Service Broker Certificate?

is it in SQL or SCCM site server,

please let me know.

Microsoft Security | Intune | Configuration Manager | Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
    2025-09-21T11:31:11.3966667+00:00

    In SQL Server, you can find the certificate itself in master.sys.certificates. To find out which certificate that is used by Service Broker, look in master.sys.server_broker_endpoints.

    Whether the certificate may also be stored in SCCM separately, I don't know. My expertise is with SQL Server, and I next to nothing about SCCM.

    0 comments No comments

Your answer

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