File Mover Blog

May 24, 2021

SSL Security Error on SQL-Source for MSSQL in Limagito File Mover

User: It seems that we started to receive a connection error by SQL-source which should connect to a Microsoft SQL Server recently.

This is the error message:

TFDPhysMSSQLConnection DB SQL Exception: [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

Open Database Exception [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

I googled a little and found out that it might have something to do with the fact that SQL Server now uses TLS 1.2 as standard

A: We adviced the user to switch from MSSQL to ODBC as ‘Database Vendor’

Limagito File Mover SSL Security Error ODBC

.. and asked them to check the following link:

ssl-security-error-for-microsoft-sql-driver

Limagito File Mover SSL Security Error

 

We received the following feedback:

  • Installed recent ODBC Driver for MSSQL 17 to the Server where Limagito File Mover is running.
  • Created System-DSN for specific Database with that newest ODBC-Driver.
  • Switched settings in Limagito Rules to ODBC.
  • >> Seems to work!

#FileTransfer

If you need any info about this error, please let us know.

Best regards,

Limagito Team

By Limagito-Team SQL , Share:
SEARCH