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.
SAP Knowledge Base Article - Preview