Skip to Content
avatar image
Former Member

Receiver JDBC CCerror "Could not do TCP/IP Connection to host Manufactured"

Hi,

I want to connect to MS SQL server 2000 Database from my PI 7.1 EHP1 server.

Basis team has installed MS SQL 2005 drivers in PI system by downloading it from the below link

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=c47053eb-3b64-4794-950d-81e1ec91c1ba

Network team has opened the 1433 port.

I installed 2005 drivers as I read it is backward compatible and there are plans of upgrading the SQL 2000 version to 2005 by the DB team.

Now I tried to send the data to the DB i get the below error in the receiver JDBC Communication channel.

Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Can not establish connection:: com.microsoft.sqlserver.jdbc.SQLServerException: Es konnte keine TCP/IP-Verbindung mit dem Host hergestellt werden. java.net.ConnectException: Connection timed out: connect

The parameters which I gave in the CC are

JDBC driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:sqlserver://<ip>:1433;databasename=<DBname>

Can you please suggest what could be the reason for the issue?

Thanks,

Preethi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 19, 2010 at 06:57 AM

    Hi All,

    The above is issue was solved. The network team did not open the port 1433 properly. They made some mistake in the FW rule.

    So, after the port 1433 being opened, I am able to connect to DB from XI server.

    Thanks,

    Preethi

    Add comment
    10|10000 characters needed characters exceeded