Folder and File Permissions (Master Data Services)

Applies to: SQL Server - Windows only Azure SQL Managed Instance

When you install Master Data Services, folders and files are installed in the file system at the installation path you specify for SQL Server shared features. If you use the default installation path for SQL Server shared features, the installation path for Master Data Services is drive:\Program Files\Microsoft SQL Server\130\Master Data Services. Although you can change the shared features installation path, be aware of permissions that are inherited from the parent folder and permissions that are explicitly set for Master Data Services.

Inherited Permissions

The Microsoft SQL Server folder, the Master Data Services folder, and most subfolders and files inherit permissions from the parent folder specified in SQL Server Setup. If you choose the default installation location, the parent folder that permissions are inherited from is drive:\Program Files. The following table describes the default permissions for Program Files.

Note

If you modify default permissions for Program Files, or you choose a different installation location, the Master Data Services folders and files inherit permissions from their parent folder accordingly, and the permissions might differ from those described in the following table.

Program Files Default Permissions
Group or account name Permissions
CREATOR OWNER Special permissions
SYSTEM Special permissions
Administrators Special permissions
Users Read & execute, List folder contents, Read
TrustedInstaller List folder contents, Special permissions

Explicit Permissions

The MDSTempDir folder and the Master Data Services Web.config file (in the WebApplication folder) do not inherit permissions. They have permissions that are set explicitly when you install Master Data Services, regardless of the installation path you choose. Do not modify these permissions.

MDSTempDir Permissions
Group or account name Permissions
SYSTEM Modify, Read & execute, List folder contents, Read, Write
Administrators Modify, Read & execute, List folder contents, Read, Write
MDS_ServiceAccounts Modify, Read & execute, List folder contents, Read, Write
Web.config Permissions
Group or account name Permissions
SYSTEM Full control, Modify, Read & execute, Read, Write
Administrators Full control, Modify, Read & execute, Read, Write
MDS_ServiceAccounts Read & execute, Read

For more information about the contents of the Master Data Services Web.config file, see Web Configuration Reference (Master Data Services).

See Also

Install Master Data Services