3724379 - "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist or access denied" error in Designer - SAP Data Services

• Data Services Designer Client is unable to connect to the repository.
• Error message: ODBC call for data source <> failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist or access denied. [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()). Notify Customer Support. (BODI-1112172)
  
  
  
• Additional observations:
  • Connection test to the repository from CMS is working
  • The error message in Designer displays one particular data source name, regardless of what is set in CMC
  • Telnet to the DB host from the Designer Client machine on the DB port using HOSTNAME only fails
  • Telnet to the DB host from the Designer Client machine on the DB port using FQDN is successful

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• All supported SAP Data Services Client versions
• All supported Windows operating systems
• Microsoft SQL Server

data services designer, repository connection issue, odbc sql server driver, connectionopen(connect), bodi-1112172, repository manager, sql server fqdn, hostname resolution, al_machine_info table, reserved2 column, repository update. , KBA , EIM-DS-DES , User Interface/Designer , Problem