"Cannot open connection" Error during Database Migration to Microsoft SQL Server

  • 7010505
  • 23-Jul-2012
  • 26-Aug-2016

Environment

Novell ZENworks Configuration Management
Novell ZENworks Embedded OEM Sybase Database
Microsoft SQL Server Database

Situation

Migrating ZENworks Embedded OEM Sybase database to external Microsoft SQL Server

The following is seen on the console (Linux) and in the novell-zenworks-configure.log:

INFO: The database has been successfully created.
SEVERE: Datamodel exception while getting db cofiguration
SEVERE: An error has occurred while migrating the database.
SEVERE: org.hibernate.exception.GenericJDBCException: Cannot open connection
com.novell.zenworks.configure.ConfigureException: org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: com.novell.zenworks.configure.ConfigureException: org.hibernate.exception.GenericJDBCException: Cannot open connection

Resolution

  1. Ensure that the following services are running on the MSSQL Server database server:
    • SQL Browser
    • SQL Server Agent
  2. Rerun the database migration