It's all about the answers!

Ask a question

Connect ELM702 to MSSQL Server 2008

Sean F (1.3k22769) | asked May 15, 11:25 a.m.
edited May 15, 11:26 a.m.

I am trying to connect a ELM702 installation to MSSQL Server 2008 in a test environment

ELM702 officially requires MSSQL2016 or 2017 or 2019

It installs and runs on many unsupported platforms (e.g. Win11, WinServer2008) with only minor warning messages

But trying to connect to an unsupported version of MSSQL generates an explicit  blocker.

The startup wizard runs and successfully connects to the server with the MSSQL driver sqljdbc42.jar OK and the Create Table button appears

But when I hit 'Create Tables' I get the error

The "" feature could not start. ( CRJAZ1092E
Caused by:
The system schema could not be created. (java.lang.RuntimeException)ID CRJAZ0820E
Caused by:
SQL Server 2016 or 2017 or 2019 (13.x or 14.x or 15.x) is required but version "10.50.4000" was detected instead. ( CRJAZ1256I

The is just a temporary dev/test deployment I am trying to create. It is not a production deployment.

Does anybody know if there is a specific reason why the blocker has been implemented by development?

Does anybody know any hacks or ways round the blocker so I can run the product in a test environment with ELM702 hooked up to MSSQL2008 (or any other MSSQL other than 16,17,19)?


4 answers

permanent link
Sean F (1.3k22769) | answered May 17, 2:15 p.m.
edited May 17, 2:26 p.m.

Thanks for your advice and guidance David and Paul.

Yes, I was aware of the MSSQL deprecation plans, thanks.

I am upgrading an RTC database from 406 to 702 and then moving it to a new network.

The upgrade involves 406->407->502->6061->702->702 on New Network (Server Rename)

I was trying to do the upgrade phase (406->702) on a single MSSQL server (which happens to be 2008)

But since that is not possible (the repotools -addTables command also has the explicit version blocker on it) I will deploy additional versions of MSSQL Server.

It looks like 3 versions of MSSQL will be the minimum. MSSQL2008 (for 406 and 407), MSSQL2014 (for CLM502 and 6061) and MSSQL 2017/2019 (for ELM702)

permanent link
Paul Ellis (1.3k613) | answered May 16, 8:00 a.m.
Hi Sean,

There is nothing about your suggestion that makes me feel comfortable.  As David Honey has mentioned, SQL Server struggles with the complex SQL that ELM uses and this has become worse over time.

Although ELM702 officially requires MSSQL2016 or 2017 or 2019, we have seen upgrades on 2016 simply fail to complete:

So, the simple answer is that there isn't an override here. 
The more pertinent answer is, that you don't want to go there and would be likely to hit more issues and lose more time than it saves you

permanent link
David Honey (9256) | answered May 16, 5:29 a.m.

You should also be aware that IBM is encoraging customers to move away from MS SQL Server to either Oracle or DB2 for production environments. I believe there is an intent to drop support for MS SQL Server inb a future release. If you just want to kick the tyres, you can use the built-in Apache database support.

permanent link
David Honey (9256) | answered May 16, 4:50 a.m.
Re: Does anybody know if there is a specific reason why the blocker has been implemented by development?

Yes, to prevent/discourage users from using sunsupported database vendor versions!
Product management decides which data vendors and versions are supported in each release. Each additional one requires testing effort. So this is a business decision based on containing test effort.

Your answer

Register or to post your answer.