on 09-08-2011 5:26 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
check:
or try to add poolWaitingTime in the CC Config of the JDBC Channel #831162
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.