Is it possible if I wanted to set up SQL Server 2008 R2 instance so that it only accepts SSL Connection?
I am getting different answers and based on my testing, it will accept non-SSL connection even though I have force encryption as instructed on http://msdn.microsoft.com/en-us/library/ms191192%28v=sql.105%29.aspx
The last comment from Edward Dorland on this thread (SQL Server SSL connection - What am I missing?) pointed out "SQL server uses ssl for encryption, that doesnt need a cert at the client side."
Could anyone explain in detail?