SAP Knowledge Base Article - Preview

1771817 - Special character in the password causes Designer to not be able to connect to the repository, even though in CMC the connection is successful - Data Services 4.x

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.