Jdbc connection

[Former Member]

Hi,

I having the following error in CC JBDC:

Error during database connection to the database URL 'jdbc:sqlserver://E0200397:1433;DatabaseName=INTCARDB000' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://E0200397:1433;DatabaseName=INTCARDB000': com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect'

But the database exits and is correct. What happen?

[MichalKrawczyk]

Hi,

can you XI machine connect to the SQL server ?

(not from your laptop but from XI server)

check it - maybe some ports are closed

Regards,

michal

[Former Member]

Ensure all ports are open - if unsure how, ask your basis person...

OR

1) try connecting to the db using your sql mgmt studio - able to connect successfully?

2) run a netstat on the OS and see if any connections are failing

sincerely,

NM