Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [encryption-key]

The tag has no usage guidance.

0
votes
0answers
25 views

How to test a master key regeneration?

Following up after a situation on an important LIVE server - where I have the master key backed up, but the decryption password for that master key backup file is missing. I can't open the master ...
0
votes
1answer
46 views

Restore fails on unencrypted database

I tried to restore an unencrypted database to a different server and it failed with the error: "Cannot find certificate with thumbprint". This suggests the database is encrypted but it is not. ...
1
vote
0answers
21 views

Do any databases other than SAP ASE support key custodians?

SAP Sybase ASE supports the notion of a key custodian. This allows for a setup where the trust can be split between two roles: the database administrator and a key custodian. The database ...
4
votes
1answer
862 views

Column Level Encryption in SQL Server 2016

When using the column level encryption approach, do we need to explicitly close the symmetric key in stored procedures/views or its not required? how it's handled for the subsequent openings ? eg: ...
3
votes
1answer
420 views

TDE Change Encryption Key - Is it safe?

We use SQL Server 2012 Enterprise Edition and Transparent Data Encryption (TDE). Microsoft have a command to let you change the encryption on the database "ALTER DATABASE ENCRYPTION KEY". The docs ...
2
votes
2answers
144 views

Service Master Key inaccessible, SSRS key only one backed up

I’m working with a SQL Server 2012 instance that had a service master key, other secondary keys, and a SSRS key. The instance was uninstalled and reinstalled with new service accounts, and the master ...
8
votes
1answer
13k views

How do I check that the database master key encryption is valid?

I have a scenario where I'm restoring a db from one server to another. On the source server, the database master key (DMK) is encrypted with both a password and the service master key (SMK). When I go ...
5
votes
1answer
90 views

Is there any reason to back up these system-created certificates?

I understand the need for backing up keys and user defined certificates, but is there any reason that we should back up these certificates that are system-created? MS_AgentSigningCertificate ...
2
votes
2answers
2k views

Where/How to generate the validation key and decryption key for SSRS View State Validation

According to this Technet article, I need to : Generate a validation key and decryption key by using the autogenerate functionality provided by the .NET Framework. The step does not explain how to ...