2
votes
1answer
105 views

What is the location of the SQL Server Fallback Certificate?

We are required to use encryption with SQL Server, so we have enabled ForceEncryption. According to the documentation, if a certificate is not provided, SQL Server will generate its own internal ...
1
vote
1answer
36 views

Protecting SQL from Profiling

We have some sensitive IPR in some Stored Procedures. We encrypt the stored procedures. However, at the point they are created, they are plain text. Is there anyway we can prevent SQL Server Profiler ...
2
votes
2answers
266 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 ...
0
votes
2answers
837 views

Encrypting an ODBC connection

Situation: We have a SQL Server 2008 R2 database sitting in a data centre We would like to allow analysts to connect to the database and query the data using desktop based tools (e.g. Tableau) via ...
1
vote
1answer
179 views

Using Encrypting File System on SQL Server data files

I have SQL Server 2008 standard edition running on Windows Server 2003. I need to encrypt the databases. One obvious option is to upgrade to enterprise edition and use TDE. However, this might not ...
2
votes
1answer
1k views

SQL Server encryption - rotate keys for PCI compliance

PCI compliance requires annual rotation of keys. The definition of "rotation of keys" that I keep coming across is decrypting your data, then re-encrypting with a new key. Really? Everyone out there ...
3
votes
2answers
504 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 ...
0
votes
1answer
142 views

SQL Server encryption/decryption

As part of disaster recovery testing I am trying to ensure that I am able to recreate my DB and still be able to decrypt previously encrypted strings. So here is what I am doing as a test... ...
1
vote
0answers
120 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
437 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?
6
votes
2answers
4k views

Certificates in SQL Server 2008

I need to implement SSL for transmissions between my application and Sql Server 2008. I am using Windows 7, Sql Server 2008, Sql Server Management Studio, and my application is written in c#. I was ...
2
votes
1answer
373 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 ...
1
vote
3answers
2k views

What are the steps to TDE encrypt a SQL Server 2008 database?

We have been trying the steps here: http://msdn.microsoft.com/en-us/library/cc278098.aspx but keep getting this error: Msg 15151, Level 16, State 1, Line 1 Cannot find the certificate 'tdeCert', ...
0
votes
3answers
304 views

Which tools are most commonly used to auto-encrypt backups for SQL Server 2005?

I am looking to automate the encryption of my backups, and SQL Server 2005 does not appear to include built in functionality to do the work. Similar to the question here - ...
1
vote
2answers
522 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 ...
1
vote
3answers
105 views

Sql Server - Error attaching mdf file encrypted via Encrypted File System (EFS)

I am getting an error trying to attach a database whose files were previously encrypted via EFS. The actuall error message is Msg 5120, Level 16, State 101, Line 9 Unable to open the physical file ...
1
vote
4answers
355 views

Encrypting a column in SQL Server 2000 database

I've been tasked with encrypting several years worth of sensitive data (don't ask) stored in a SQL Server 2000 Database. I need to encrypt both historical data and come up with a process to encrypt ...
3
votes
2answers
3k views

How to enable encrypted connections to a SQL Server instance?

How can I enable an encrypted network connection to SQL Server? What have I to do on the client and on the server side?