-
Title
Unable to connect to database using SQL Authentication mode (MSSQL source) that requires TLS using versions lower than 7.0.28. -
Description
Connecting to the database using SQL authentication mode.
Requires TLS encryption when connecting to database.
Errors received:
Failed to connect to DB; connection-string='DRIVER=libtdsodbc.so;SERVER=X.X.X.X;PORT=1433;UID=SQLSyslog-ng_d;PWD=XXXXXXXX;DATABASE=XXXXXXXX;ClientCharset=UTF-8', ODBC-Diag='SQLRETURN: SQL_ERROR(-1) | entry: 1, SQLSTATE: 08S01, error_code: 20009, error_string: [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist | entry: 2, SQLSTATE: 08001, error_code: 0, error_string: [FreeTDS][SQL Server]Unable to connect to data source', driver='s_XXXX_SensitiveRequestLog#0'
-
Resolution
WORKAROUND: TLS support for the MSSQL source was added in syslog-ng 7.0.28.
STATUS: Change Request SYSLOGDEV-5978 has been added in 7.0.28. From the 7.0.28 Release Notes"
"New features in syslog-ng Premium Edition (syslog-ng PE) version 7.0.28 "New Features" section:
"mssql() source: support for TLS authenticationFrom version 7.0.28, syslog-ng PE supports TLS authentication for the MSSQL source driver." -
Change Request
SYSLOGDEV-5978