Questions tagged [encryption-key]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
24 views

Azure Database Encryption (ERROR ON WEB APP)

Currently I have an azure subscription which has a server and database. I already encrypt a column in a table. i am using "always encrypted" method. Now I want to generate a .pfx file after I ...
1
vote
0answers
81 views

How to find out everything that is affected by a master key?

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
64 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
897 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: ...
2
votes
1answer
459 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
146 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 ...
7
votes
1answer
15k 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
93 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 ...