Question : If I have a cert in SQL Server, used for backups: Can backups still be created after cert […]
Tag: certificate
Grant User permission to view XE results via sys.fn_xe_file_target_read_file
Question : I need to grant a user (MyDomainJohnSmith) permission to view one particular XE session results using sys.fn_xe_file_target_read_file I […]
Changing a certifcate+key algorithm by dropping & recreating with the same names
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?
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
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
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
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
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?
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 […]
Sharing certificates encryped by password between DBs and instances
Question : Question: I am trying to create a single (self signed) certificate and deploy across many databases and instances. […]