Symptom
- Job using SQL Server datastore will sporadically fail with following error.
Error "ODBC call <SQLDriverConnect> for data source <> failed: <[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied." - Other database connections in same job work without error.
- Failing connection will work successfully in other enviornments.
Read more...
Environment
SAP Data Services
Product
SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2 ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2
Keywords
NamedPipe, Connectivity, HKEY_LOCAL_MACHINE , KBA , EIM-DS-EXE , Job Execution , 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.