MCL - CREATE TABLE permission denied in database

Summary:

When running the Multi-Company application, the user receives the following error.

Symptoms:

Cause:

The user that is assigned to the database connection property as defined in the Admin tool (windows or SQL authentication) does not have Create Table permissions to the database in the error message.

Resolution:

This is required since the application creates tables in the master company database. If you are unsure which company database is the master company, this is the one chosen during the initial configuration of multi-company.

The user using the application will need:

1. Read/write permissions to the company databases (db datareader & db datawriter, see image)
2. Create Table permissions on the master database

 Once the user permissions are configured as described, it should resolve the error. 

Properties:

Applies To:

• Multi-Company 4x