Have you ever wondered how to change the keys for the encryption for an already encrypted database. For this you can use “Key Rotation”. Key rotation is the process of decrypting data with the old encryption key and encrypting the data with the new encryption key. But how to use the Key Rotation with SQL… Continue reading How to change the keys for the Encryption for an already encrypted database
Category: SECURITY
This category contains the post which talks about the security in sql server
Regeneration of the Master Key fails when we try to take the backup of the original database and restore it on other instance of sql server on some other server
We have a production database in which the data is encrypted. The encryption follows the following hierarchy 1) The data is encrypted using Symmetric key 2) The symmetric key was encrypted using asymmetric key 3) The asymmetric key was encrypted using the master key of the database 4) The master key of the… Continue reading Regeneration of the Master Key fails when we try to take the backup of the original database and restore it on other instance of sql server on some other server
USE OF KERBEROS AUTHENTICATION IN SQL 2005
Kerberos is a network authentication protocol which can be used only with TCP/IP protocol. So if the client connects to the sql server with the Named Pipe Alias Kerberos is not used. Every service that will use Kerberos authentication needs to have an SPN set for it so that clients can identify the service on… Continue reading USE OF KERBEROS AUTHENTICATION IN SQL 2005