Which version of SSL (or TLS) does SQL Server 2005 SP3 use when Force Encryption is on? I'm running Windows Server 2003 SP2.

link|improve this question

40% accept rate
Doesn't really answer your question but I believe you'll need a certificate for encryption as in the Force Encryption flag alone won't turn it on. – jl. Feb 11 '11 at 18:29
@jl Actually you don't need a certificate. If no certificate is found in the SQL config, the service account's user store or in the machine store then SQL will generate its own self-signed certificate (starting with SQL 2005). – squillman Feb 11 '11 at 21:09
feedback

1 Answer

It will use what ever settings are specified by the certificate specifications.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.