KB15467: 'SQLDriverConnect. Invalid username/password; logon denied’ error occurs when a user is attempting to execute reports in MicroStrategy Developer 9.4.1 and 10.x.

Salesforce Solutions Architect • Strategy

For a particular user, the following error occurs when executing reports in MicroStrategy Developer 9.4.1 and 10.x: SQL Generation Complete QueryEngine encountered error: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. Invalid username/password; logon denied.

SYMPTOM:
For a particular user, the following error occurs when executing reports in Strategy Developer 9.4.1 and 10.x:


SQL Generation Complete QueryEngine encountered error: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. Invalid username/password; logon denied.

CAUSE:
The user may be using Warehouse Pass-through and is using an incorrect warehouse login to access the data, as shown below:

ACTION:
Disable the Warehouse Passthrough option for the user or apply the correct warehouse login to access the data.

Comment

0 comments

Details

Knowledge Article

Published:

June 19, 2017

Last Updated:

June 19, 2017