Secure MSSQL Connection

Chris_O_Brien · January 28, 2021, 11:31am

Hi

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

Thanks

Christian_Schmitz · January 28, 2021, 12:04pm

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)

William_Reynolds · January 28, 2021, 5:24pm

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

Chris_O_Brien · January 28, 2021, 5:38pm

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

Christian_Schmitz · January 28, 2021, 5:43pm

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

Chris_O_Brien · January 28, 2021, 5:58pm

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

Christian_Schmitz · January 28, 2021, 8:13pm

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