My Oracle Support Banner

GoldenGate For SQL Server Connectivity Error (Doc ID 2940485.1)

Last updated on JANUARY 28, 2024

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


We are trying to setup credentials for SQL Server on Oracle GoldenGate Marketplace Microservice for Non-Oracle 21.3. We have ODBC drivers installed on the OCI VM Linux and have configured the odbc.ini file. When we enter the details on OGG admin server credential page and hit the "connect to database" button we are getting the following error


Login failed. Database operation failed: Couldn't connect to sqlserver. ODBC error: SQLSTATE 08001 native database error -1. [unixODBC][Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate]Failed to open data source sqlserver for user"


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.