Database connection encryption

  • Hi all,

    I'm planning to migrate some applications to connect to our SQL 2008 R2 instances using encrypted connections. However, one thing I'm trying to understand is whether I can use encrypted and unencrypted connections at the same time? For instance, I only need to encrypt connections that use a specific database, and leave all other ones as they are. Is this possible, or is the connection encryption an all or nothing process?

    Thanks,

    Dan

  • You can set clients to ask for encrypted connections. The server with a cert can allow this, while still allowing unencrypted connections from some clients.

    http://msdn.microsoft.com/en-us/library/ms189067%28v=SQL.105%29.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply