[opencms-dev] Installation of OpenCms 10.5.4 on MS SQL Server 2014 fails

[Schliemann, Kai]

Hi list,

did anybody successfully install OpenCms 10.5.4 with / on a Microsoft SQL Server 2014?

OpenCms seams to create the database and tables correctly but the setup wizard stops during module import.

The opencms.log says:

21 Mrz 2019 16:06:46,975 ERROR [encms.db.generic.CmsUserDriver:2217] . User Driver          : System roles creation failed
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 14d18a1<mailto:net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 14d18a1>.
                at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:773)
                at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2208)
                at org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:827)
                at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:5163)
                at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3410)
                at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:166)
                at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1365)
                at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:2057)
                at org.opencms.main.CmsShell.<init>(CmsShell.java:532)
                at org.opencms.main.CmsShell.<init>(CmsShell.java:453)
                at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:151)
Caused by: java.sql.SQLException: Ungültiger Objektname 'CMS_GROUPS'.
                at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
                at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
                at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
                at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
                at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
                at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
                at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
                at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
                at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
                at org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:759)
                ... 10 more
21 Mrz 2019 16:06:46,976 ERROR [  org.opencms.main.OpenCmsCore: 370] Critical error during OpenCms initialization: Unable to initialize the user driver.
org.opencms.main.CmsException: Critical error during OpenCms initialization: Unable to initialize the user driver.
                at org.opencms.main.OpenCmsCore.setErrorCondition(OpenCmsCore.java:370)
                at org.opencms.main.CmsInitException.setErrorCondition(CmsInitException.java:113)
                at org.opencms.main.CmsInitException.<init>(CmsInitException.java:84)
                at org.opencms.db.generic.CmsUserDriver.internalCreateDefaultGroups(CmsUserDriver.java:2219)
                at org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:827)
                at org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:5163)
                at org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:3410)
                at org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:166)
                at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1365)
                at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:2057)
                at org.opencms.main.CmsShell.<init>(CmsShell.java:532)
                at org.opencms.main.CmsShell.<init>(CmsShell.java:453)
                at org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:151)

Other components involved:
Windows Server 2012 R2
Tomcat 8.5
Java 1.7

Any help appreciated.

Best regards
Kai
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20190321/cd6475bb/attachment.htm>