Knowledge Document: Certificate remint and server upgrades fail to complete when using MS SQL encryption



ZENworks 2020 Update 2


When using ZENworks with a MS SQL database, there is an option to enable encryption.  When encryption is enabled, actions that make a direct SQL connections will fail.  Two such areas where these failures would occur would be attempting to upgrade the servers and when activating reminted certificates.

ERROR (from microfocus-zenworks-configure.log)

[DEBUG] [[DatabaseUpgradeUtils] [1] [root] [ConfigureUtility] [] [DatabaseUpgradeConfigureAction: getConnection] [] [] [] [ConfigureUtility]
[DEBUG] [DatabaseUpgradeUtils] [1] [root] [ConfigureUtility] [] [Exception while connecting to database] [] [] [] [ConfigureUtility]
[ERROR] [ZENworksConfigure] [1] [root] [ConfigureUtility] [] [I/O Error: DB server closed connection.
com.novell.zenworks.configure.ConfigureException: I/O Error: DB server closed connection.
    at com.novell.zenworks.configure.util.DatabaseUpgradeUtils.getConnection(
    at com.novell.zenworks.configure.util.DatabaseUpgradeUtils.getConnection(
    at com.novell.zenworks.configure.actions.DetectDevicesVersionInZoneConfigureAction.configure(

ERROR (from MS SQL error log)

2020-05-06 20:05:30.00 Logon       Error: 17835, Severity: 20, State: 1.
2020-05-06 20:05:30.00 Logon       Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library. [CLIENT: ]


ZENworks does not support SQL Encryption.  Encryption would need to be disabled on the SQL side to allow the processes to complete. 

Access document on support portal here


Configuration Management
Comment List