SQL 2008 Express connection to 11.5

[Former Member]

Is it even possible to make this connection with 2008? My connection summary is below. Do I need to do a driver update or do I have something incorrect in my data server connector?

Name Value

Connector IDBC

ConnectorType SQL

DatePrefix '

DateSuffix '

Description MSSQL Database

Enabled true

InitCommand

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

Name sandbox

PoolMax 100

PoolSize 1

ServerPackage com.lighthammer.Illuminator.connectors.IDBC

ServerURL jdbc:sqlserver://MII\SQLEXPRESS:1433;database=sandbox

Timeout 30

UseCount 256

UserName sa

ValidationQuery SELECT GETDATE()

WaitTime 30

[jcgood25 · Accepted solution]

Your JDBCDriver syntax below does not jive with the Una2000 sql driver that comes preinstalled with 11.5. You'll need to either drop the new jar file into the lib directory and restart servletexec, or reconfigure your driver settings to look more like the default Northwind data server.

[Former Member]

Jeremy's finding is correct.

Please use the SAP Note 990322. The note is written for SQL 2005, but still holds good for SQL Server 2008 Express as well.

1. Get the latest sqljdbc.jar file (version 2.0)

2. Use the SAP Notes 990322 instructions

3. On the SQLExpress 2008, Surface Area configuration - Enable SQL Server Browser service

4. SQL Server 2008 Configuration Manager - TCP/IP (right click properties) - IPAddresses tab - IPAll row - remove the entry in TCP Dynamic ports - Add port number 1433 in TCP Port row.

5. Restart the SQLServices

[Former Member]

Hello,

MS sqljdbc.jar file (version 2.0) require the java 1.5 or higher. So If I remember right, xMII 11.5 is running under

Sun JDK 1.4.2_xx and will bring you problems. MS sqljdbc.jar file Version 1.2 will work for Sun 1.4.2_xx but

will not support the MS SQL 2008.

BR

Pedro Iglesias

[Former Member]

Any errors in the log?

[jcgood25]

Udayan - I'm guessing 'No suitable driver' is the error he's seeing.