enabling SQL Encryption

jbla9028
jbla9028 used Ask the Experts™
on
My company wants to try to implement SQL encryption using SSL certificates. My database administrator is working on this but we're unsure if this typically requires sany network or application level changes. when enabling this feature do we need to do anything to our existing applications to utilize the encryption or will applications just know that the connection is encrypted?

we're using SQL Server 2008 R2 Enteprise and our application is built using .net 4.0
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011
Commented:
SQL Server Encrypted Connection is transparent to the application.  All changes are on configuration settings.

More here:

How to: Enable Encrypted Connections to the Database Engine
http://msdn.microsoft.com/en-us/library/ms191192%28v=sql.105%29.aspx

Encrypting Connections to SQL Server
http://msdn.microsoft.com/en-us/library/ms189067%28v=sql.105%29.aspx
simple add encrypt=yes on connection string, that is it....
the communication will be encrypted automagically
Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes;Encrypt=yes;

Open in new window

Author

Commented:
BuggyCoder, if we do not add the Encrypt flag, will the encryption work (assuming not) also if we do not have it enabled, will database connectivity fail or will it fail back to unencrypted?
it will use unencrypted connection...
Top Expert 2011
Commented:
That's defined by the ForceEncryption option on the database.  If it is set to Yes, all client/server communication is encrypted and clients that cannot support encryption are denied access.

Sql Server Configuration Manager

Author

Commented:
Thank you! This information helped me greatly

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial