It can be, but not default.
And here says "The level of encryption used by SSL, 40-bit or 128-bit, depends on the version of the Microsoft Windows operating system that is running on the application and database computers."
In some cases I think you can restrict the connecting IP addresses as well to add to the security. Not related to encryption but can be more secure.
Not being a Wintel weenie, I am a little confused. The link above references the SQL Server Native Client. Filemaker uses the MS ODBC Driver. Can one specify connection string keywords to modify the connection the driver creates? If so How? Is this something done at the OS level, the Registry level or is it done thru Filemaker?
1 of 1 people found this helpful
Sorry I'm not expert of MSSQL, so put link and didn't write using my word.
FM can use Native Client ODBC driver.
I think this is supported for ESS, since FM document says about only server, not driver.
(At least worked with my very little test)
This ODBC driver has checkbox for data encryption, so don't need to use connection string.
- Use strong encryption for data
When selected, data that is passed through connections that are made using this DSN will be encrypted. Logins are encrypted by default, even if the check box is cleared.
Sorry "my very little test" don't use secure setting, it need set up SSL certificate on server. Please try yourself
And, "SQL Server" driver 6.01.7601.17514 also has same check box (but help file has no description for it).