SAP Knowledge Base Article - Preview

3717940 - After a fresh installation of MSSQL and SAP Data Services unable to register newly created MSSQL local repository in CMC > Data Services - SAP Data Services 14.x

Symptom

  • After a fresh installation of MSSQL and SAP Data Services unable to register newly created MSSQL local repository in CMC > Data Services: There is a problem to connect to repository: [The TCP/IP connection to the host XX.XX.XX.XX, port 1433 has failed. Error: "Connection refused: connect (local port XXXXX to address 0:0:0:0:0:0:0:0, remote port 1433 to address XX.XX.XX.XX (hostname)). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". ] 
  • MS SQL Server Management Studio connection to database works
  • Repository creation in Data Services Repository Manager works
  • Repository can be associated with the job server in Data Services Server Manager


Read more...

Environment

  • SAP Data Services 14.x
  • MSSQL Database
  • Windows

Keywords

KBA , EIM-DS-DEP , Deployment, Installation, Upgrade , 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.