SAP Knowledge Base Article - Preview

2801644 - 'Invalid instance' when creating a Datastore to Microsoft SQL Database (BODI 1111341) - SAP Data Services 14.2

Symptom

Creating datastore in SAP Data Services to Microsoft SQL Server 2008 R2 which is using named instances leads to following BODI-1111341 error:

WARNING: Cannot establish database connection. 'ODBC call <SQLDriverConnect> for data source <> failed: <[Microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid connection.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance ()).>. Notify Customer Support.'(BODI -1111341)


Read more...

Environment

  • Microsoft SQL Server 2008 R2
  • Data Services 4.2
  • ODBC Driver 6.01

Product

SAP Data Services 4.2

Keywords

KBA , EIM-DS-SVR , Administration/Server , Problem

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.