How to Grant Permissions for Data Import

  • Article

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

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 2000 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 2000

  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

  2. In SQL Server Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand <SQL cluster name>, expand Security, right-click Logins, and then click New Login.

  3. In the SQL Server Login Properties - New Login dialog box, on the General tab, in the Name box, type <domain name>**\**DTSImportand then click OK.

To create the DTSImport database account in SQL Server 2005

  1. Click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, click Connect.

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

  4. In the Login - New dialog box, in the Login name box, type <domain name>**\**DTSImportand then click OK.

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

  1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

  2. In SQL Server Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand <servername>(Windows NT), expand Security, and then click Logins.

  3. In the right pane, right-click the database account, DTSImport, and then click Properties.

  4. In the SQL Server Login Properties DTSImport dialog box, on the Database Access tab, in the top box, select a database (for example, msdb).

  5. In the bottom box, specify the role for the account. For msdb, select the following roles:

    • db_datareader

    • db_dtsadmin

    • db_dtsltduser

    • db_dtsoperator

  6. Repeat step 4 for the <sitename>_DataWarehouse database. Select these roles for this database:

    • db_datareader

    • db_datawriter

    • db_ddladmin

    • db_owner

  7. Click OK.

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

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, click Connect.

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

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

  5. 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).

  6. 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

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

    • db_datareader

    • db_datawriter

    • db_ddladmin

    • db_owner

  8. Click OK.

See Also

Other Resources

Configuring the Business Management Server

Configuring the Data Warehouse and Analysis Server