2
votes
2answers
223 views

Do I need to back up the SQL Server Encryption Password and Symmetric Key?

I'm trying to setup SQL Server to use Cell-Level Encryption on some sensitive data. It seems straightforward per this example on the MSDN: Create the Master Key with a strong password. Create a ...
1
vote
1answer
194 views

Adding column-level encryption after-the-fact in SQL Server 2008?

I am writing a web-app that will, at some point in the future, need to perform column-level encryption of a portion of the data it stores to our database running on SQL Server 2008 Express. It would ...
1
vote
0answers
59 views

Suggestion for encrypting database files in SQL 2008 Standard Cluster

I have an SQL 2008 Server configured as a fail-over cluster an have a requirement to have the database files (mdf/ldf) encrypted. We have tried to use EFS for this but there are a lot of issues doing ...
3
votes
2answers
409 views

SQL Server Column Level Encryption - Rotating Keys

We are thinking about using SQL Server Column (cell) Level Encryption for sensitive data. There should be no problem when we initially encryption the column, but we have requirements that every year ...
1
vote
0answers
117 views

Can encryption be disabled for the login handshake in SQL Server 2005 or 2008

When a client Application connects to SQL Server the login credentials are sent over the network in a TLS Encrypted Handshake Message. For testing purposes I would like to have the login credentials ...
0
votes
2answers
424 views

How to encrypt data at rest

How can you encrypt data at rest on Sql Server Web Edition? TDE is apparently not an option, but I don't know what else is available. Any recommendations?
2
votes
1answer
296 views

Decrypt column in SQL 2008

I need to decrypt a column in a table that has previously been encrypted at application level. The algorithm is DES at 192 bits and block size = 64. I have the password but DecryptByPassPhrase ...
2
votes
1answer
657 views

SQl server 2008 permission and encryption

i have made columns in some of the tables encrypted in sql server 2008. Now as i am a db owner i have the access to encode and decode the data using the symmetric key and certificate. But some other ...
1
vote
1answer
4k views

SqlServer 2008 How to correctly install/configure SSL certificate to require encrypted connections

SqlServer 2008 instance is installed on Windows Server 2008 and is running under this identity: NT AUTHORITY\NETWORK SERVICE SSL cert from third-party CA has been installed in Local Computer\Personal ...
1
vote
2answers
512 views

SSRS 2008 Encryption Key reset after server reboot

I have a development XP (SP2) SQL 2008 box being actively used by developers. When this computer is restarted, the SSRS encryption keys become deactivated and the only way to get SSRS working again is ...