Problems installing 11.2 with external MSSQL

Hello.

We are attemting a fresh installation of zenworks 11.2, trying cot connect to an external MSSQL Dtabase.

Systems are:

Zenworks Server : Windows 2008R2 SP1
Database server : Windows 2008R2 SP1
SQL server : Microsoft SQL server 2008R2

I used the Zenworks setup.exe -c to create the database initially, and all seems fine.

Then use setup.exe to install Zen11.2 and connect to the database.

At the end of the installatation, these these errors :

Status: ERROR
Additional Notes: ERROR - ConfigureAction failed!: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: com.novell.zenworks.datamodel.exceptions.ConnectionException: org.hibernate.exception.GenericJDBCException: Cannot open connection
at com.novell.zenworks.datamodel.temp.ZoneCreator.createZone(ZoneCreator.java:143)
at com.novell.zenworks.datamodel.utils.hibernate.ZoneCreator.doWork(ZoneCreator.java:180)
at com.novell.zenworks.datamodel.utils.hibernate.ZoneCreator.main(ZoneCreator.java:508)
Caused by: com.novell.zenworks.datamodel.exceptions.ConnectionException: org.hibernate.exception.GenericJDBCException: Cannot open connection
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:437)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:177)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.createDefaultFolders(HibernateAbstractSession.java:658)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession._postPasswordValidationInitialize(HibernateAbstractSession.java:437)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAdministratorSession._postPasswordValidationInitialize(HibernateAdministratorSession.java:161)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.loginAsSystem(HibernateAbstractSession.java:409)
at com.novell.zenworks.datamodel.services.DirectServiceStoreImpl.loginAsSystem(DirectServiceStoreImpl.java:224)
at com.novell.zenworks.datamodel.temp.ZoneCreator.getServiceStore(ZoneCreator.java:189)
at com.novell.zenworks.datamodel.temp.ZoneCreator.createZone(ZoneCreator.java:97)
... 2 more
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:118)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1294)
at com.novell.zenworks.datamodel.session.hibernate.HibernateSessionImpl.newTransaction(HibernateSessionImpl.java:30)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.beginTransaction(AbstractHibernateSessionImpl.java:84)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.createDefaultFolders(HibernateAbstractSession.java:621)
... 8 more
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:615)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
... 15 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1406)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:594)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:514)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:681)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:608)
... 18 more

Custom Action: com.novell.zenworks.install.customcode.configure.ConfigZoneCreateAction
Status: FATAL ERROR
Additional Notes: FATAL ERROR - class com.novell.zenworks.install.customcode.configure.ConfigZoneCreateAction FatalInstallException: ConfigureAction failed!: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: com.novell.zenworks.datamodel.exceptions.ConnectionException: org.hibernate.exception.GenericJDBCException: Cannot open connection
at com.novell.zenworks.datamodel.temp.ZoneCreator.createZone(ZoneCreator.java:143)
at com.novell.zenworks.datamodel.utils.hibernate.ZoneCreator.doWork(ZoneCreator.java:180)
at com.novell.zenworks.datamodel.utils.hibernate.ZoneCreator.main(ZoneCreator.java:508)
Caused by: com.novell.zenworks.datamodel.exceptions.ConnectionException: org.hibernate.exception.GenericJDBCException: Cannot open connection
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:437)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:177)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.createDefaultFolders(HibernateAbstractSession.java:658)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession._postPasswordValidationInitialize(HibernateAbstractSession.java:437)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAdministratorSession._postPasswordValidationInitialize(HibernateAdministratorSession.java:161)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.loginAsSystem(HibernateAbstractSession.java:409)
at com.novell.zenworks.datamodel.services.DirectServiceStoreImpl.loginAsSystem(DirectServiceStoreImpl.java:224)
at com.novell.zenworks.datamodel.temp.ZoneCreator.getServiceStore(ZoneCreator.java:189)
at com.novell.zenworks.datamodel.temp.ZoneCreator.createZone(ZoneCreator.java:97)
... 2 more
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:118)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1294)
at com.novell.zenworks.datamodel.session.hibernate.HibernateSessionImpl.newTransaction(HibernateSessionImpl.java:30)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.beginTransaction(AbstractHibernateSessionImpl.java:84)
at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.createDefaultFolders(HibernateAbstractSession.java:621)
... 8 more
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:615)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
... 15 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1406)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:594)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:514)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:681)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:608)
... 18 more

Very keen to get help with this!

Don

The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.