OGG-00552 Database operation failed: Couldn't connect to XXXX. ODBC error: SQLSTATE 28000 native database error 18456.

(Doc ID 2169005.1)

Last updated on APRIL 12, 2017

Applies to:

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

Symptoms

Not able to connect to SQL Server Database through ggsci console, getting below error:

2016-07-22 10:56:52 WARNING OGG-00552 Database operation failed: Couldn't connect to XXXX. ODBC error: SQLSTATE 28000 native database error 18456.
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'USER'.
ERROR: Database operation failed: Couldn't connect to XXXX. ODBC error: SQLSTATE 28000 native database error 18456.
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'USER'. Failed to open data source XXXX for user USER.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms