Force encryption on server not working?

Hi,

I am at a loss here, unless I misunderstand the whole point about server encryption. My 2005 SQL server has a certificate from a trust CA, I have turned on the 'force encryption' flags on the server. My understanding is any client will be "force" to connect with encryption? I found out that unless I turn on encryption on my clients, the server will allow connections without the requiring encryption. Am I missing something here? Thanks for any help you can provide.

Hi anhtuan,

Your understanding is correct. If you force encryption on the server, then all connections from clients will be encrypted; if the client doesn't support encryption (e.g., very old MDAC clients), then the server will reject the connection. Basic question -- I assume that you restarted the server after setting the FORCE ENCRYPTION setting?

Il-Sung.