Security Compliance

Error after backing up and restoring the EminentWare database to SQL Server 2016/2017/2019

This article addresses an error that occurs when you restart the EmminentWare service after performing a backup and restore of the EminentWare database to SQL Server 2016 (or newer) from an older version. Error: EminentWare Service cannot be started. System.Exception: Incorrect syntax near TRIPLE_DES. at EminentWare.DataGridService.DataGridService.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

First published date

10/31/2018 2:53 PM

Last published date

11/4/2021 8:09 AM

Overview

The following error occurs when restarting the EminentWare service after performing a backup and restore of the EminentWare database to an SQL Server 2016 (or newer) from an older version:

Service cannot be started. System.Exception: Incorrect syntax near 'TRIPLE_DES'.
at EminentWare.DataGridService.DataGridService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

Product section

Patch Manager

Cause

  • TRIPLE_DES is deprecated in SQL Server 2016/2017/2019

Resolution

  1. Change the EminentWare DB compatibility to SQL Server 2014 mode.
  2. Start the EminentWare Data Grid Service.
    Patch Manager should now operate normally. 

 

If you have upgraded your SQL server above version 2014 the currently installed EminentWare database will throw a 1064 error upon the connection attempt and you will see the 'TRIPLE_DES' error in the EminentWare logs for Patch Manager. This is because you cannot user and/or migrate the Patch Manager database to the higher SQL version without enabling compatibility mode. If you cannot change the compatibility mode on the SQL server, then you would need to redeploy Patch Manager to avoid the 'TRIPLE_DES' failure.

Please reach out to Solarwinds Technical Support for further details if you are seeing this error and need further support.