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

Last updated on AUGUST 27, 2015

Applies to:

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

Goal

why my dblogin failed for ogg on sql serer database patch

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

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
ator'.
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.
 

Solution

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