Problem

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'.

Applies to

Credit Hound v6

Solution

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 ProductCredit Hound
Ref NumberKBA-03-03-009
Document Date7/7/2017
Original AuthorVince Hodgson
Document Versionv1.1
Last updated 20/03/2018
Update Author Vince Hodgson