Siebel Administration >  SBL-ADM-01042: Login failed for specified username, password, and ODBC datasource combination

SBL-ADM-01042: Login failed for specified username, password, and ODBC datasource combination

This error message is most often reported in combination with the error messages below:
NET-01003 : Internal: invalid encryption authentication information
SRM-00016 : Unable to initialize the Database environment

To effectively troubleshoot this error one needs to understand where and in what context the error is being reported.

Cause

The error message is indicative of its cause:

It indicates an incorrect username or password combination, or incorrect data source. If the error is reported in a server component's log file, the likely scenario is that the one or more of these parameters set at the component level is incorrect.

If in the event that the above parameters are correct, then the error can also be reported when the database connection is unable to be established (this could be due to the database server being down, network connectivity issues between the Siebel server and database server, incorrect versions of the database client connectivity software).

If this error is reported when a user accesses the Server Administration UI screens, it could be due to the user not having the required "Siebel Administrator" responsibility.

Diagnostic Steps

Verify the username, password and datasource values at the component level. The username and datasource can be verified from the component log file. The password is not indicated in the log file.

Verify database connectivity is not an issue - test connection outside of the Siebel environment (such as via SQL*Plus (in case of Oracle) or Query Analyzer (MSSQL) or command center (in case of DB2).

Verify network connectivity is not an issue between the database server and the Siebel server.

Verify connection from within the Siebel environment (via "odbcsql" utility) - Refer - How Do You Test Connectivity Through ODBC Data Sources Created by Siebel? (Doc ID 475610.1)

Verify supported versions of the database client connectivity software that is being used (Refer Certifications on My Oracle Support). Refer - Using Certifications on My Oracle Support for Siebel CRM Products (Doc ID 1492194.1).

Verify if the user has "Siebel Administrator" responsibility (In the Siebel client, navigate to Site Map > Application Administration > Responsibilities).

Solution

If the username, password and/or datasource are incorrect at the component level, re-enter the values (either from the Server Administration UI screens or Server Manager command line) and restart the Siebel server.

Resolve any network or database connectivity related issues.

If incorrect client connectivity software is present, reinstall the software to comply with the requirements.

Grant the user "Siebel Administrator" privileges only if the error was encountered upon accessing the Server Administration screens (that is, provided the user is entitled to access those views).