My Oracle Support Banner

why dblogin failed to connect SQL Server via valid dsn with sql server authentication (Doc ID 2043514.1)

Last updated on NOVEMBER 07, 2019

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.


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.