Skip to Content
0
Former Member
Feb 18, 2009 at 08:30 AM

SQL 2005 Express connection problems

55 Views

I am having problems connecting to an SQL Express 2005 computer with a database.

I have setup data connection in MII:

SQL Express 2005

JDBCDriver:

com.microsoft.sqlserver.jdbc.SQLServerDriver

Serverurl:

jdbc:sqlserver://elda039\SQLEXPRESS:1433;database=PP5000

Info messages:

Created Connection pool [jdbc:sqlserver://elda039\SQLEXPRESS:1433;database=PP5000]:

Error messages:

Unable to fill connection pool for jdbc:sqlserver://elda039\SQLEXPRESS:1433;database=PP5000

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.SocketTimeoutException: connect timed out

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

at com.sap.xmii.Illuminator.tools.database.JDBCDriverWrapper.connect(JDBCDriverWrapper.java:35)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.sap.xmii.Illuminator.tools.database.ConnectionPool.createConnectionObject(ConnectionPool.java:301)

at com.sap.xmii.Illuminator.tools.database.ConnectionPool.<init>(ConnectionPool.java:80)

at com.sap.xmii.Illuminator.tools.database.ConnectionHolder.addDBConnectionPool(ConnectionHolder.java:121)

at com.sap.xmii.Illuminator.server.Server.createHolder(Server.java:267)

at com.sap.xmii.Illuminator.server.Server.access$300(Server.java:20)

at com.sap.xmii.Illuminator.server.Server$1.run(Server.java:125)