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’
.. and asked them to check the following link:
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!