Hi all,

If I set up a MS SQL 2005 Server with an SSL certificate as per this article here (How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console) does that mean that all connections to all databases on that server will need to be encrypted?

What if I don't click the "force protocol encryption" flag, does that mean it is available but not enforced?

Any advise you can offer would be great.