Symptom
- TCP/IP protocol enabled
- Named Pipes protocol enabled
- Performance issue viewing data
- Long delay before data grid appears
- localhost was used for database server name
- Different error appears if Named Pipes protocol disabled
- Error: ODBC call <SQLDriverConnect> for data source <0.0.0.0> failed: <[Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [1214]. >. Notify Customer Support.
- Error: ODBC call <SQLDriverConnect> for data source <0.0.0.0> failed: <[Microsoft][SQL Server Native Client 10.0]TCP Provider: The requested address is not valid in its context.>. Notify Customer Support.
Read more...
Environment
- SQL Server
- SAP Data Services
Product
SAP Data Services 4.0 ; SAP Data Services 4.1
Keywords
DS, DSXI, SQL, MSSQL, TCP, TCP/IP, Named Pipes , KBA , EIM-DS , Data Services , 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.