I have a VPS that is fully managed by a third party hosting company, and I just had them install a SSL Certificate on the SQL 2008 server which resides on it. My question is how do I adjust my cinnection string that indicates that is a secured and encrypted SSL connection?
Online I found:
however, when I run this on my test server which have no SSL, it works also, but I would imagine that I should have received an error that says "No SSL installed", or something along those lines.
If the above is correct and if I should not get an error even though I have no SSL, then how can I tell if my connection is encrypted?