Adding a Dedupe server to the DLO Admin Console results in 'Could not authenticate user'

Problem

Attempting to Add a New or Manage an existing Dedupe Server in the Desktop Laptop Option (DLO) Administration Console, generates the error 'Could not authenticate user'.

Error Message

Cause

The user you are currently logged on with is not listed in the "User_Info" table of the Dedupe database.

Solution

Either

• Log onto the DLO Admin server as the DLO service account, when Adding or Managing Dedupe servers.

or

• Manually add the logged on domain user into the "User_Info" table of the Dedupe database. To do this, run the following command in an Administrative Command Prompt, on the DLO Admin server ;

sqlcmd.exe -E -S .\INSTANCENAME -d dedupedb -Q "insert into user_info values (5, 'DOMAINNAME\USERNAME' ,NULL, 1)"

Note:  Change the INSTANCENAME and DOMAINNAME\USERNAME references to appropriate values  
Make sure that the Mindtree StoreSmart Dedupe Server Service, DLO Administration Service and the SQL (DLO) Service are all running as the same account.

Then attempt to configure the Dedupe server again.