My Oracle Support Banner

Essbase SQL/IF Load Rule Not Connecting to SQL Server in an 11.1.2.4 Environment, Error ODBC Layer Error: [28000] ==> [[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '<Windows_User_Name/password>'.] (Doc ID 2543497.1)

Last updated on APRIL 07, 2021

Applies to:

Hyperion Essbase - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

Using SQL/IF to connect to a SQL Server to pull data is failing.  The error from the application log:

[Mon May 06 17:51:00 2019]Local/<appname>/<dbname>/<username>/12828/Info(1021041)
Connection String is [DSN=<connection_name>;UID=...;PWD=...;]
 
[Mon May 06 17:51:00 2019]Local/<appname>/<dbname>/<username>/12828/Info(1021006)
SELECT Statement [SELECT * FROM <dbname>] is generated
 
[Mon May 06 17:51:00 2019]Local/<appname>/<dbname>/<username>/12828/Info(1021013)
ODBC Layer Error: [28000] ==> [[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '<Windows_User_Name/password>'.]
 
[Mon May 06 17:51:00 2019]Local/<appname>/<dbname>/<username>/12828/Info(1021014)
ODBC Layer Error: Native Error code [18456]
 
[Mon May 06 17:51:00 2019]Local/<appname>/<dbname>/<username>/12828/Error(1021001)
Failed to Establish Connection With SQL Database Server. See log for more information

Cause

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
Symptoms
Cause
Solution
References


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