JDBC sender- Communication channel Ping failed

[Former Member]

Hi All,

I am working on Proxy to JDBC scenario in PI 7.3.

When I am trying to ping the Communication channel its giving error, error details are in the attached document,

Please provide me the solution.

Thank you in advance.

Regards,

Amar.

[ambrish_mishra]

Hi,

Possibly it could be a firewall issue. Is the database on the same network domain as PI ?

Ambrish

[Former Member]

Hi Ambrish,

No firewall issue. PI and database are in different domain. Successfully ping from PI OS level.

Amar.

[iaki_vila]

Hi Reddy,

Contact with your basis team because probabbly the port used to connenct to the database is not open. Also tell us the format that your are using to the driver connection and the database vendor, may be something is wrong.

Regards.

[Former Member]

Hi,

I am using SQL Server 4133 port and i have checked with network team they confirmed that port is open and have removed all firewall restrictions.

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

Connection : jdbc:sqlserver://XX.XX.X.XX:1433;databaseName=XXXX

Regards.

[iaki_vila]

Hi,

Is the port 4133 or 1433?, could your database team access with the user that are you using?

Regars.

[Former Member]

Hi,

Port is 1433 and the DB team can access with the user that I am using.

Regards,

Amar.

[ambrish_mishra]

Hi Amar,

Is it a typo above. port should be 1433.

Ambrish

[ambrish_mishra]

Hi Amar,

please check 2 steps:

• The driver is correctly installed. Please check the driver version.
• Try adding the host name to /etc/hosts file on PI App server

Ambrish