Skip to main content

Search

Welcome to Tibero GTS!

TBR-130005: Authentication failed error occurs when performing MSSQL DBLink in Tibero

Document Type | Technical Information

Category | Interface/Integration

Applicable Product Versions | 6FS06, 6FS07, 6FS07PS, 7FS02, 7FS02PS

Document Number | TIITI012

 

Issue 

Note
The environment is as follows.
  • Tibero: Tibero7 FS02, JDK 1.8 (Linux)
  • MSSQL: MSSQL 2012 (Windows)
  • MSSQL JDBC Driver: sqljdbc4.jar, sqljdbc41.jar, sqljdbc42.jar
The following operations cause the error TBR-130005: Authentication failed.
  1. When attempting to connect to MSSQL through DBLink in Tibero
  2. When attempting to connect directly to MSSQL using tbsql
TBR-130005:Authentication failed. - The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.
Error : "Certificates do not conform to algorithm constraints".
 

 

Cause

This occurs due to compatibility issues between the MSSQL JDBC driver and the Java version used regarding SSL/TLS settings.
 
 
 

Solutions

As of May 2025, Tibero7 FS02 officially supports up to MSSQL 2008.
If the supported range expands in the future, it will be reflected in the manual, so please be sure to check the relevant manual before creating a DB Link. This issue arises from compatibility problems between third-party products such as MSSQL and Java, and cannot be resolved by changing Tibero settings alone.
A workaround is to use a compatible combination between the Java version used on the Tibero server and the MSSQL JDBC driver.
Note
Tibero to MSSQL connection test results
JAVA Version
JDK 1.8
JDK 1.6
MSSQL JDBC Driver
sqljdbc4.jar sqljdbc41.jar sqljdbc42.jar
sqljdbc4.jar
MSSQL Version
SQL Server 2016
SQL Server 2012
Test Result
MSSQL connection successful
MSSQL connection successful
 
 
 
 
 
 

Related to