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 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

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
Goal
Solution


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