SQL 2005 Express connection problems

[Former Member]

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)

[former_member201407]

Did u check by just ip address of that server instead of host name in the ServerURL as shown below

jdbc:inetdae:<your server ip>:1433?database=<your db name>&sql7=true

Regards

Som

[Former Member]

Now i get the following error, but I have created this user in the SQL database and made him dbadmin.

Am i overseeying something

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

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'kardex_0067'.

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

at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)

at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)

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

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

at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(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)

[former_member201407]

Just use this ServerURL as follows and tell me what this is saying

jdbc:inetdae:10.131.17.217:1433?database=PP5000&sql7=true

Regards

Som

[Former Member]

problem is solved, we have changed the computer name into ip adress. Restarted the service, because the server had some problems. Thanks very much!