---
title: "Error - 2147217933 occurred in module MTenement:LoadTenements"
canonical: "https://servicedesk.maxgeo.com/space/LC/1263370363/Error%20-%202147217933%20occurred%20in%20module%20MTenement%3ALoadTenements"
format: markdown
---
<u>**Problem:**</u>

1. After installation / upgrade, the following error is returned:


![image-20240513-034038.png](media://af470c88-18b6-4a68-b4ae-818b602b9492)


<u>**Cause:**</u>

1. There are insufficient / incorrect permissions in relation to the SQL Database.

<u>**Solution:**</u>

<span style="color: #bf2600">*This requires access to the SQL Server - which should only be conducted by appropriately trained and experienced persons.  Although you can contact servicedesk.maxgeo.com for assistance if you don't have such a person on hand, please bear in mind that you are responsible for ensuring security protocols required by the company is communicated to us.*</span>

1. <u>*Usual Preference*</u>: Within SQL Server, right-click on the database, select "Properties" - which will open a new window.  Select "Membership" and tick the box for db_owner.
2. <u>*For Tighter Access Security*</u>: Run a script to create a new Role (example below in Additional Info) after which you need to refresh SQL Management Studio, then follow step 1 in relation to this new Role you have created.

<u>**Additional Info:**</u>

- <u>*How do I know SQL Database I need to sort permissions for?*</u>  Please refer to the related article [What SQL Server / Database am I using for LeaseControl?](http://smartnet.max-geoservices.com.au/kb/?View=entry&EntryID=395)
- <u>*How can I create a new role?*</u>  Remember you need to ensure you are not in breach of your company's security protocols before executing the following in relation to the database in question:

```sql
CREATE ROLE db_executor
GRANT EXEC to db_executor
```