Article Number
000035403
Applies To
Product(s): Archer
Version(s): All Versions
Primary Deployment: On Premises
Description
When attempting to load a license in the Archer Control Panel (ACP) and you get the following error message:
"Error Occurred During Licensing. See the output window for details"
After Clicking OK, click on the below Output section as shown in the screenshot
This is a sample error which displays in the Output section in Archer Control Panel.
[01:19:14:88] Begin Control Panel starting
[01:19:10:75] Control Panel starting
[01:19:11:50] Connecting to configuration service
[01:19:11:97] Connected to configuration service in 0.466s
[01:19:11:97] Starting Plugin Manager
[01:19:11:99] Started Plugin Manager in 0.023s
[01:19:11:99] Finding Plugins
[01:19:12:74] Finding Plugins completed in 0.739s
[01:19:12:74] Loading Plugin 'Certificate Manager [Local Machine]'
[01:19:12:76] Loading Plugin 'Certificate Manager [Local Machine]' completed in 0.023s
[01:19:12:76] Loading Plugin 'Configuration Report'
[01:19:12:84] Loading Plugin 'Configuration Report' completed in 0.080s
[01:19:12:84] Loading Plugin 'Job Engine Manager'
[01:19:12:87] Loading Plugin 'Job Engine Manager' completed in 0.031s
[01:19:12:87] Loading Plugin 'Local Settings'
[01:19:12:90] Loading Plugin 'Local Settings' completed in 0.036s
[01:19:12:90] Loading Plugin 'Monitoring Console'
[01:19:12:93] Loading Plugin 'Monitoring Console' completed in 0.023s
[01:19:12:93] Loading Plugin 'Output'
[01:19:13:20] Loading Plugin 'Output' completed in 0.274s
[01:19:13:20] Loading Plugin 'Installation Settings'
[01:19:13:85] Loading Plugin 'Installation Settings' completed in 0.651s
[01:19:13:85] Loading Plugin 'Instance Management'
[01:19:14:03] Loading Plugin 'Instance Management' completed in 0.181s
[01:19:14:03] Control Panel started in 3.283s
End Control Panel starting
[01:28:45:70] The EXECUTE permission was denied on the object 'usp_set_company_license', database 'archerinstance', schema 'dbo'.
Cause
This can be caused by one of the following:
-
The user running the Archer Control Panel not having enough rights to the Instance database
-
The user added in the database tab in ACP does not have dbo over the instance database.
Resolution
To resolve the issue you can log into Windows as the service account who is running the App Pool in IIS and the other Windows services or launch the Archer Control Panel as the service account. This will allow the Archer Control Panel to have the same permissions to the instance database as other parts of Archer.
Also, double check the username added in database tab in ACP if this user has dbo or not. (if you are not using windows integrated).
