My Oracle Support Banner

Essbase SQL/IF Load Rule Not Connecting to SQL Server in an 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 MARCH 21, 2024

Applies to:

Hyperion Essbase - Version to [Release 11.1]
Information in this document applies to any platform.


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


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.