How to Grant Permissions for Data Import

  • Article

This topic provides steps for creating the DTSImport account on the Data Warehouse database server and granting this account access to the following Data Warehouse databases:

Database

SQL Server roles

msdb

db_datareader, db_dtsadmin, db_dtsltduser, db_dtsoperator

<sitename>_DataWarehouse

db_datareader, db_datawriter, db_ddladmin, db_owner

Follow these steps on the Data Warehouse and analysis server or on the computer where you installed the Data Warehouse database. Follow the steps that are valid for the version of SQL Server that you installed.

To create the DTSImport database account in SQL Server

  1. Connect to SQL Server 2005 or 2008.

  2. In SQL Server, expand SQL Server computer, expand Security, right-click Logins, and then click New Login.

  3. In the Login - New dialog box, in the Login name box, type <domain name>\DTSImport,and then click OK.

To associate the DTSImport database account with the database roles in SQL Server

  1. In SQL Server, expand <servername>(Windows NT), expand Security, expand Logins, right-click the database account, DTSImport, and then click Properties.

  2. In the Login Properties DTSImport dialog box, in the left pane, click User Mapping.

  3. In the right pane, in the Users mapped to this login box, in the Map column, select the check box for the appropriate database (for example, msdb).

  4. In the Database role membership for <database name> box, select the check box for the appropriate role on the database. For msdb, select the following roles:

    • db_datareader

    • db_dtsadmin

    • db_dtsltduser

    • db_dtsoperator

  5. Repeat step 3 for the <sitename>_DataWarehouse database. Select these roles for this database:

    • db_datareader

    • db_datawriter

    • db_ddladmin

    • db_owner

  6. Click OK.

See Also

Other Resources

Configuring the Business Management Server

Configuring the Data Warehouse and Analysis Server