question

dholt avatar image
dholt asked

What exactly does ForceEncryption do?

I can't seem to find a definitive answer on ForceEncryption on SQL Server 2008 R2. If I set ForceEncryption=Yes on a SQL Server 2008 R2 server, does this require every application that connects to a DB on the server to include "Encrypt=True" in the application's connection string in order to connect to the DB? In other words, does setting ForceEncryption=Yes on a SQL Server 2008 R2 server make the server refuse connection from any application that does not have "Encrypt=True" in the application's connection string?
encryption
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
JohnM avatar image
JohnM answered
According to this TechNet article, you are correct. http://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx Excerpt: *"When the ForceEncryption option for the Database Engine is set to Yes, all client/server communication is encrypted and clients that cannot support encryption are denied access."* Hope this helps!
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks, I was seeing some ambiguity in everything I read. This would seem to confirm what I thought before I started to think too hard about it.
0 Likes 0 ·
Awesome! If that answered your question, feel free to mark it as the answer so that others will know the question has been answered. Thanks!
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.