Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
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

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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