I was wondering if SQL server 2008 R2 has any default security if you're using it via ODBC or SQL Server Management Studio?
I was reading about SSL here https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx
The issue is forcing encryption right now will break a lot of things and would take a while. I was wondering if there is anything that's set up to encrypt by default to buy some time while we figure ssl out.
We have hundreds of users and some people designed their own database to pull from this one. It would be a huge task with limited amount of time. I have a trusted cert it's just force encryption plan fell out of place. So I guess right now nothing's encrypted - am just trying to see if anything exist by default.