Secure MSSQL Connection


Does anyone know if it’s possible to connect to an MSSQL database securely using an SSL cert?


Sorry, I can’t find anything on it.

If the ODBC Driver supports it, there may be a connection parameter to set.
(for SQLDatabaseMBS or SQLConnectionMBS classes in our MBS Xojo SQL Plugin)

You may be able to establish a permanent SSH Tunnel (quick search found this article), not sure if that’s helpful.

Thanks very much William. I’ll look into it, though it is on an internal network

We have SSH in the plugin to tunnel directly from within the app. :grinning:

You mean it’s already build in to the SQL plugin? Or do I need to provide a cert?

We have sample with SSH2TunnelMBS class to connect via MySQL, but yo may adapt it for MS SQL.