cancel
Showing results for 
Search instead for 
Did you mean: 

Error in adapterlog: JDBC connection error

Former Member
0 Kudos

Hi Experts,

I am getting this error during database connection to the database URL 'jdbc:sqlserver:// <servername>:1433;database=HRBD' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://<servername>:1433;database=HRBD': com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out'

I am able to connect this server from Microsoft SQL Server2005(Which does not require the port number) but when I am trying to connect from PI JDBC sender adapter ,I am getting this error.

It is a SQL Server.JDBC driver seems ok(com.microsoft.sqlserver.jdbc.SQLServerDriver) because I connected the Staging database server from PI but unable to connect to this production database.

After starting the channel ,after 5-7 minutes I am getting this error.

Need your help on urgent basis!!

regards

Anupam

Accepted Solutions (1)

Accepted Solutions (1)

naveen_chichili
Active Contributor
0 Kudos

Hi Anupam,

check if your DB server is up and also check if your JDBC drivers are installed properly.

Try to ping your DB server from your PI Run-->cmd --> ping DB IP/host name if ping is successfull check your firewall connections from PI to DB.

Regards,

Naveen

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Experts,

My problem is solved.It was with the port/firwall only.Network team have opened the port and I am able to connect the database now through PI.

Thanks a lot for all your help!!

Former Member
0 Kudos

check:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c059d583-a551-2c10-e095-eb5d95e03...

or try to add poolWaitingTime in the CC Config of the JDBC Channel #831162

Former Member
0 Kudos

1>I got only this port number from business

2>Can you tell me how to disabale this firewall?will I be able to do it?

Or I need to inform network team?

Note:I was able to connect thsi server throgh Microsoft SQL Studio Express

but unable from PI

Former Member
0 Kudos

Hi,

Can you tell me how to disable this firewall?will I be able to do it?
Or I need to inform network team?

Since the server maintained by Network and security team, its better that they carry out this activity.

regards

Ramesh

Former Member
0 Kudos

Hi,

One more thing,

Ask your network team to permit a fixed port so that the PI server to can communicate with the database

regards

Ramesh

naveen_chichili
Active Contributor
0 Kudos

Hi Anupam,

Ask your network team to fix the port so that your PI server would be able to connect to database.

Regards,

naveen

Former Member
0 Kudos

Hi Navin,

I made a telnet test from putty giving the server name and port number and it showed me the "connection timed out".

But I made telnet test to other database which resulted in successful connection.

So is it a firewall issue with that particular databse?

In that case only network team of that databse can handle this issue?

Thanks,

Jaydeep

Former Member
0 Kudos

Hi,

In that case only network team of that databse can handle this issue?

Yes, this has to be handled by the Network and Security team

regards

Ramesh

Former Member
0 Kudos

Hi Navin,

>

> I made a telnet test from putty giving the server name and port number and it showed me the "connection timed out".

> But I made telnet test to other database which resulted in successful connection.

> So is it a firewall issue with that particular databse?

> In that case only network team of that databse can handle this issue?

>

> Thanks,

> Jaydeep

Few things that mght help u

1. Check the port no for the DB that is getting timed out. .check

2. Disable the firewall. and check

3. Consult the N/w and the DB team.. .telling clearly the issue

Good Luck

XA

Former Member
0 Kudos

Hi,

Cross check with the following.

1. Deploy the drivers again

2. check with your IT team whether the port is open for communication

Also find the discussion in the following thread with some solutions

regards

Ramesh