ENM 8.3.4 "The edition of the selected SQL server is insufficient"

How can we help you today?

Issue
There is an error with the Event Notification Module v8.3.4. When using SQL 2016 Enterprise edition the installer will give an error stating "The edition of the selected SQL server is insufficient" and will not allow you to proceed. The following pictures show the installer error and installer log output.

Product
Power Monitoring Expert 9.0

Environment
Software Installation Files

Resolution
The work around to this is to edit the broker file to allow the installer to overlook this error

1. Log into SQL and run the following Query: select @@version

2. You should get back something similar to the following: Take note of the number before (X64) that is highlighted. You will need this for the broker file.

Microsoft SQL Server 2016 (SP2-CU4) (KB4464106) - 13.0.5233.0 (X64)
Nov 3 2018 00:01:54
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)

3. Go to the path of the ENM installer and copy the install folder to a different drive on your computer so you will be able to edit and save changes to the broker file. The installer folder can be found in the following path:

("..\Event Notification Module")

4. Go to the broker file located in the following path and open it in notepad to edit it.

("..\Event Notification Module\Installer\Setup\Broker.xml"

5. Under the CheckSqlVersion tag, add the following tag.(Note if the number you copied from step 2 is different then put that number in the highlighted area).

6. Remove the edition check completely by deleting the <CheckSqlEdition> tags and contents.

7. Save file and exit installer. Then run it again.