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