cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC: Error while connecting to MS SQL using JDBC adapter

Former Member
0 Kudos

Hi All,

Does anybody know what the error below mean and how to resolve it:

- 2007-04-10 14:10:26 PDT: Processing started

- 2007-04-10 14:05:57 PDT: Error: Accessing database connection 'jdbc:sqlserver://DBServer:1433;DatabaseName=name' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://DBServer:1433;DatabaseName=name' : com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.UnknownHostException:

Thx

Navin

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Looks like it cannot connect to the database because the host or port number is not correct.

Verify if DBServer is valid. Can you ping it from XI server? You may also have to verify the port number of the database instance using the administrator tool.

Regards,

Bill