SSL Security

  • 24 May

    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