Using Licensing Tool: Unable to calculate new license key

Initial Issue: Clients upgrading their SES servers may run into issues while using the License Tool provided in the SES Upgrade PDF links.

Product version affected: SES v6.3 to v7.1

Environment:
1 - Clients will have already verified that master keyfile (*.dbk) is used for SES and SDConnex match.
2 - The SDConnex service runs under a domain service account (e.g. <DomainName>\<Service account> (an SES recommended best-practice)

Root Cause:

The DomaiName\Service account running SDConnex service may not have adequate rights to validate the data on the SQL Server (or within the SES Database itself).

To correct this, elevate the SQL rights of that account as follows:
Under Server Roles account can have public

Under User Mapping ensure that SD_Admin, SD_User, Public and db_owner database roles have also been defined, as in the image below.

Once the required role changes have been made, it should be possible to re-run the license tool and obtain the correct information (the existing License Key will be successfully read from the database and either:

• Validated as OK, or

• A new License Key may be required.

Workaround:

Try to run the license validation tool from the command prompt as administrator