Credit Hound synchronisation fails during account opening. The following message is displayed:
On inspection of the Credit Hound.txt log file, the Exception reads as follows:
The EXECUTE permission was denied on the object 'xxxxxxx', database 'Credit Hound COMP000x', schema 'dbo'.
Credit Hound v6
The SQL Database must be configured to allow each user the execute code permission for the dbo schema in the Credit Hound database.
Open SQL Server Management Studio
Expand the tree view to Databases>Credit Hound COMP000x>Security>Schemas
Double-click dbo to open its properties.
Select Permissions, then View database permissions
Select each of the users in turn, scroll down the list of Permissions and grant Execute to the user
Click OK, then OK and close SQL Server Management Studio
|Related Product||Credit Hound|
|Original Author||Vince Hodgson|
|Update Author||Vince Hodgson|