Microsoft Deployment Toolkit
Documentation Library Assigning the Appropriate Permissions to the MDT DB |
Depending on the tasks to be performed, you may need different permissions on the MDT DB. Table 180 lists the types of tasks to be performed and the corresponding SQL Server server roles and database roles required to perform them.
Table 180. Roles and Required Roles
To perform this task |
You need these roles |
Create a new MDT DB from an existing database |
db_owner database role in the MDT DB |
Create a new MDT DB and database at the same time |
sysadmin or dbcreator server role in the SQL Server instance in which the MDT DB resides |
Connect to an existing MDT DB |
db_datareader database role in the MDT DB or rights to the individual tables and views in the MDT DB |
Modify the schema of the MDT DB |
db_ddladmin database role in the MDT DB |
Modify the configuration information stored in the MDT DB |
db_datawrite database role in the MDT DB or rights to the individual tables and view in the MDT DB |
View the configuration information stored in the MDT DB |
db_datareader database role in the MDT DB or rights to the individual tables and views in the MDT DB |
For more information on how to assign these permissions see Identity and Access Control (Database Engine).
Related Topics