why dblogin failed to connect SQL Server via valid dsn with sql server authentication

(Doc ID 2043514.1)

Last updated on MAY 10, 2018

Applies to:

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


why my dblogin failed for ogg on sql serer database patch

GGSCI (SAQTST01) 4> dblogin sourcedb <dsn_test>, userid ogg_operator,password Gg

2015-07-30 15:36:50 WARNING OGG-00552 Database operation failed: Couldn't conn
ect to <dsn_test>. ODBC error: SQLSTATE 28000 native database error 18456. [Micr
osoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'ogg_oper
ERROR: Database operation failed: Couldn't connect to <dsn_test>. ODBC error: SQ
LSTATE 28000 native database error 18456. [Microsoft][SQL Server Native Client 1
0.0][SQL Server]Login failed for user 'ogg_operator'.Failed to open data source
<dsn_test> for user ogg_operator.


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