cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

Hi Everyone,

Please help me to solve the below communication channel connectivity issue.

User has created a new communication channel through Integration Builder but while checking communication channel monitor I can see below error.

Database Connectivity Test      Could Not Open connection to jdbc:sqlserver://xx.xx.xx.xx:1433; databaseName=xxxx


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

I checked the connectivity issue through ping or telnet from apps server to target system and its going through fine. Port is also there in service file.

I asked user and he is able to connect from given userid and password through SQL Server Management Studio.

Best Regards,

Avinash Tripathi

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi All,

My apologize, I have not replied on time.

The issue got resolved by changing the driver version and then restart Java Instance.

Thanks for all your suggestion.

Best Regards,

Avinash Tripathi

iaki_vila
Active Contributor
0 Kudos

Hi Avinash,

Please close the thread with your last answer as correct answer for further help to others SCN members.

Regards.

Former Member
0 Kudos

Hi Avinash,

On the Database server check if the SQL Server Browser service is running and recheck if "Allow remote connections to server" is checked for the database.

Regards,

Alka Panday.

Former Member
0 Kudos

Hi Avinash,

On prod server, Go to SE38, run the program RSBDCOS0

Do a Telnet from here and check if the return code is OK. You might have to take help of Basis if you do not have access for t code.

Regards,

Pranav

Former Member
0 Kudos

Hi Pranav,

Our PI system is not dual stack, its only single stack (Java) system.

Best Regards,

Avinash Tripathi

Former Member
0 Kudos

Hello,

As Baskar suggested, please try reinstalling the drivers.

BR,

Diptee

Former Member
0 Kudos

Do a system restart and try once.

Regards,

Pranav

baskar_gopalakrishnan2
Active Contributor
0 Kudos

Few things to see..

Please make sure jdbc drivers for the right version of jvm is installed.  You might want to check Microsoft web site for it.  They recommend diff drivers for 2000, 2003, 2008 versions...

If the sql server side settings is in default settings, this server might not allow remote connection to be established. You already confirmed about firewall port thing.


Former Member
0 Kudos

Hi Baskar,

When I ping the communication channel its giving me below attached error in server0 log.

where I can see this error, do I need to check at PI server level or in SQL Server.

Best Regards,

Avinash Tripathi

former_member184720
Active Contributor
0 Kudos

Error message indicates that there is a compatibility issue with deployed drivers and your java version.

If your java version is >=1.6 then you should use sqljdbc4.jar drivers.

if it is <=1.5 you should use sqljdbc.jar

nabendu_sen
Active Contributor
0 Kudos

Hi Avinash,

It seems a firewall issue.

You are accessing through 1433. Ask them to add your IP in their firewall.

Regards,

Nabendu.

Former Member
0 Kudos

Nabendu,

Just for confirmation, IP address of PI system or SQL Server.?

Best Regards,

Avinash Tripathi

nabendu_sen
Active Contributor
0 Kudos

Hi Avinash,

If the database is out of PI server network, you need to check with Network teams so that they can remove. Every network has its own level of settings, so it needs to be checked with both.

Regards,

Nabendu.

Former Member
0 Kudos

Hi Nabendu,

Network team has checked the connectivity & firewall and everything is fine.

Even I done telnet from my PI server to destination SQL server system and its fine.

Best Regards,

Avinash Tripathi

former_member184720
Active Contributor
0 Kudos

If you are using SQL Server 2000 driver , then class name should be as follows:

Driver class:com.microsoft.jdbc.sqlserver.SQLServerDriver
URL:jdbc:microsoft:sqlserver://<db_server>:port;databaseName=<db_name>
Former Member
0 Kudos

Hareesh,

Thanks for your prompt reply.

The Driver class and URL is fine because in development and production system its working fine.

Best Regards,

Avinash Tripathi

former_member184720
Active Contributor
0 Kudos

It depends on the drivers deployed on the system.

However can you share the complete error log? You can check for nwa logs or XPI inspector to trace.