Symptom
- Cannot log into designer.
- Error: "Cannot open connection to the repository. The error message from the underlying DBMS is <ODBC call <SQL Driver Connect> for data source <data source name> failed: <[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'username'. Notify customer support.> (BODI-20006)"
- Can connect from CMC with no issue.
- There is a special character in the password and remove the character and the connection works from Designer.
Read more...
Environment
Data Services 4.x
Product
SAP Data Services 4.0
Keywords
DSXI, BODS, password, @ , KBA , EIM-DS , Data Services , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.