sql server – Page 2 – SQL Server Faq

SECURITY

How to change the keys for the Encryption for an already encrypted database

August 19, 2008

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…

SECURITY

USE OF KERBEROS AUTHENTICATION IN SQL 2005

May 6, 2008

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…