certificate Archives

Changing a certifcate+key algorithm by dropping & recreating with the same names

By adminPosted on July 25, 2022

Question : We have a situation where a symmetric key has been created (a long time ago) using TRIPLE_DES. This […]

Force Client to Validate SSL Certificate?

By adminPosted on June 20, 2022

Question : When SQL Server uses the Force Encryption with value “yes” then if in the client-side we use encrypt=true […]

Domain Certificate Authority Generated Certificate and SQL Server – Keyset does not exist

By adminPosted on June 18, 2022

Question : I do not have much experience with certificates or certificate terminology, so I may be incorrect in how […]

ola-hallengren backup solution with encryption is not encrypting

By adminPosted on May 14, 2022

Question : Installed OH’s scripts and they run great. sqlserver 2017 standard edition in a testing/dev environment. testing before rolling […]

SSDT Schema Comparison for Stored Procedure signed by a Certificate

By adminPosted on May 10, 2022

Question : I am using SSDT 14.0.50730.0 in Visual Studio Professional 2015. I am comparing databases between two instances and […]

Permissions in triggers when using cross database certificates

By adminPosted on May 9, 2022

Question : I use cross database certificates (as explained by Erland Sommarskog) to control access to a certain database in […]

How to get certificate expiration date for certificate in mirroring endpoint in SQL Server 2016 Always On Availability Group?

By adminPosted on April 6, 2022

Question : I created a domain-independent 2-node SQL Server 2016 Always On Availability Group using the Microsoft instructions: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/domain-independent-availability-groups?view=sql-server-ver15 One […]

Tag: certificate