MII 11.5.3b66 and SQL EXPRESS 2005

[Former Member]

I'm trying to create a Data Server to SQL Express 2005 using the connection string:

jdbc:inetdae:HAMELS\SQLEXPRESS:1433?database=sandbox&sql7=true

When I try to save this Data Server, the page locks up. I have to restart the services and the servers.xml file is not updated.

I've narrowed the problem down to the "\" in the servername\named instance. Has anyone else successfully set up a connection to SQLEXPRESS or a named SQLSERVER instance with 11.5.3b66?

[jamie_cawley · Accepted solution]

Use the 2005 driver and verify that tcp/ip is on and dynamic ports is turned off.

JDBCDriver

com.microsoft.sqlserver.jdbc.SQLServerDriver

ServerURL

jdbc:sqlserver://HAMELS\SQLEXPRESS:1433;database=sandbox

Jamie

[Former Member · Accepted solution]

That will do it. Thanks.

[Former Member]

Have used older version 11.5.2 b64 to create an ODBC connection to a DSN on the local xMII server, this allowed us to connect to remote SQLEXPRESS server to run Stored procedures etc.

Regards,

Emmett

[Former Member]

Thanks for that information. I've thought about going that route too. Good to know that works.