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 JULY 26, 2022

Applies to:

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

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