Troubleshooting: File System Permissions

The SQL Server service account requires access to the database files, and when using Windows authentication, the currently logged in user also requires full administrative access to the database files.

You must have full permission for both the project directory and database files to successfully connect to the Kingdom database via SQL Server.

NOTE: Changing permissions on files and folders can be confusing and potentially harmful to the privacy of your work if done incorrectly. As such, we strongly recommend that you consult your IT department before configuring or changing the permissions on any files and folders.

Access is denied

Access is denied

If you receive this error when trying to connect to your Kingdom database via SQL Server, it is likely that you do not have sufficient permission to access and write the database files (.mdf and .ldf files).

Note: The SQL Server service is also unable to see any mapped network drives you have set up (the mappings are on a per-user basis). Make sure your Kingdom project is located in a local drive.

Locating and changing file system permissions

Locating and changing file system permissions

First of all, make sure you are the administrator of your machine, or given administrative privileges to edit file system permissions.

  1. Navigate to your Kingdom project directory and open the ProjectDatabase folder. The files inside are your database files — .mdf (primary data) and .ldf (transaction log) files.
  2. Right click on the files and select Properties.
  1. In the Properties window, if you see the Security message at the bottom (see image above), click Unblock.
  2. Click Apply to save the changes.
  3. Open the Security tab.
  1. To change permissions, click Edit. The Permissions window will be displayed.
  2. In the Permissions window, select the Full control check box.
  3. Click Apply to save the changes.
  4. Click OK.
  5. Return to the Links tab in Insight and click Connect to try again.

Access denied when permissions are inherited from parent

If you attempt to attach a database that is in a directory where the permissions are inherited from a restricted parent, you will get the same "Access is denied" error. Follow the instructions below to change the permission of the project directory.

  1. Right click on the project directory and select Properties.
  2. Open the Security tab. Notice that you cannot Edit the permissions for the groups/users because they are inherited from their parent objects.
  3. Click Advanced for special permissions and advanced settings.
  4. In the Advanced Security Settings window, select Change Permissions.
  5. Click Add to insert a new user that is free from the inherited permissions.
  1. Type Users as the object name and click OK.
  2. In the Permission Entry window, select the Full control check box and click OK.
  1. In the Advanced Security Settings window, click Apply and click OK.
  2. Return to the Links tab in Insight and click Connect to try again.