New answers tagged encryption
If you create keys without a certificate like: CREATE SYMMETRIC KEY smTestKey WITH ALGORITHM=AES_256 , IDENTITY_VALUE = 'Key to protect bla' , Key_SOURCE = N'Secret pass phrase' ENCRYPTION BY PASSWORD = 'secret password'; then the following is enough: GRANT ALTER ANY SYMMETRIC KEY TO dbuser If you create symmetric keys that's encrypted by a ...
1.If you want to restore a encrypted backup to another server as usual you encounter the following error Cannot find server certificate with thumbprint …... 2.Find the cert name : in this example vestacert SELECT * FROM sys.certificates 3.backup the cert from source server (Source encryptedserver) : BACKUP CERTIFICATE vestacert TO FILE = ...
The issue was that the column wasn't long enough to hold the encrypted data. It was weird, because it was a copy.. I increased the encrypted column size and all was resolved.
Following worked for me on SQL Server 2008: OPEN MASTER KEY DECRYPTION BY PASSWORD = 'master_key_password' ALTER MASTER KEY DROP ENCRYPTION BY SERVICE MASTER KEY; ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY; CLOSE MASTER KEY For me it was essential to drop the encryption first, although the 'add' command should usually do this automatically.
I think you need to specify an "/en" option in order to change the encryption level. See this link. http://support.microsoft.com/kb/906562
Top 50 recent answers are included