Data Base connectivity Test : Could not open connection to JDBC Receiver

[former_member584059]

Hi All,

Could you please help me on below issue

I am also facing same issue (

Could not open connection to jdbc:sqlserver://xxx:1433; databaseName=xxxx)

Database Connectivity Test Could Not Open connection to

jdbc:sqlserver://xx.xx.xx.xx:1433; databaseName=xxxx

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

Scenario is : RFC to JDBC (Async)

for SQL 2012 suits to JDBC driver 7.0 ?

Port 1433 is default ? and how can we check ? (Basis team only given)

Basis team saying they Could not see Data Base name and SQL server name in them system

Please help me on this issue

Thanks & Regards

uday

[former_member584059]

Hi all,

Thank you all for your response,

your answers are used to me to resolve this issue,

everything installed correctly, just mismatched the names of Database and SQL Server,

SQL Server : 2012

SAP PI/PO : 7.5 version

JDBC Driver : mssql-jdbc-7.0jre10.jar

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

JDBC Connection : jdbc:sqlserver://xxxxxxx:1433;databasename=xxxxxxx

Once Again thank you every one.

Regards

uday

[former_member182742]

Hello uday,

Your PO system is on 7.5 which corresponds to JRE 8.0. The JDBC Driver 7.0 includes two JAR class libraries in each installation package: mssql-jdbc-7.0.0.jre8.jar, and mssql-jdbc-7.0.0.jre10.jar. Please refer to note 1829286 - Checking the drivers installed for the JMS and JDBC Adapters, and provide screenshot to show the JDBC driver that you have deployed on PO system. Then we can confirm if the deployed JDBC driver is supported by JRE 8.0 or not.

Microsoft JDBC Driver for SQL Server Support Matrix
https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matri...

System Requirements for the JDBC Driver
https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver?view=sql-s...

Best regards,

Tina

[PavanKumar]

Hi uday,

Is ports opened from PI to DB. Please check with basis team and ask to do telnet from PI.

Refer below link which addressed similar issue

https://archive.sap.com/discussions/thread/3652190

Regards

Pavan

[Faison]

Hello uday,

I am not sure about your PI system version (NW 7.???) as JDBC driver for MSSQL is different and compatible with different Java version.

You should check KBA 1615198 - PI JDBC and JMS Adapter driver's JRE compatibility to get familiar with which JDBC driver should be used here.

Then, you should check if this JDBC driver for MSSQL is deployed on your PI system.

See KBA 1829286 - Checking the drivers installed for the JMS and JDBC Adapters.

If not yet, you need to follow these 2 SAP Note/KBA to deploy this driver by using .sda file.

1770304 - PI: Preparing the com.sap.aii.adapter.lib.sda for deployment

1138877 - How to Deploy External Drivers JDBC/JMS Adapters

Besides, there is a related guided answer for your reference.

2513069 - How to deploy the external drivers for Axis/JDBC/JMS Adapter - Guided Answers

Hope all info above can resolve your issue.

Thank you.

Best Regards,

Faison Li

SAP Product Support

[former_member584059]

Hi Faison Li,

Thank you for your response,

Apologies for late reply,

Process Orchestration version is 7.5

Data Base SQL server : SQL 2012

JDBC Driver : mssql-Jdbc-7.0

On this issue i wrote a mail to Database team and Basis team. that requesting to check the Server and Database Nam's mismatched and they agreed too,and they have been provided New name's , after i replaced with new names also i am getting same error.

Could you please help me on this issue

Best Regards

uday