October 2020

How to work with a certificate in SQL Server

Adds a certificate to a database in SQL Server. Requires CREATE CERTIFICATE permission on the database. Only Windows logins, SQL Server logins, and application roles can own certificates. Groups and roles cannot own certificates. References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql?view=sql-server-ver15 https://www.mssqltips.com/sqlservertip/3299/how-to-configure-ssl-encryption-in-sql-server/