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

0 Likes

Environment

ZENworks 2020 Update 2

Situation

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(DatabaseUpgradeUtils.java:202)
    at com.novell.zenworks.configure.util.DatabaseUpgradeUtils.getConnection(DatabaseUpgradeUtils.java:236)
    at com.novell.zenworks.configure.actions.DetectDevicesVersionInZoneConfigureAction.configure(DetectDevicesVersionInZoneConfigureAction.java:253)


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: ]

Resolution

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

Labels:

Configuration Management
Comment List
Related
Recommended