How to Grant Staging Accounts Access to the Databases

  • Article

This topic provides steps for granting Commerce Server Staging (CSS) authentication accounts access to a SQL Server database. You must create an SQL Login account on the database server for each service that must access a Commerce Server 2009 database. This limits the service accounts to the access that is required to perform their functions. The SQL Server roles are created for you during the unpacking of the site.

For each account that requires access to the SQL Server database, you perform the following sequence of tasks:

  1. Create the database account in SQL Server.

  2. Associate the database account together with the database roles required for that account.

Procedures for creating these accounts are provided in this topic for SQL Server 2005 and SQL Server 2008.

For information about database access requirements for CSS, see What Database Access Permissions Must You Grant to CSS Authentication Accounts?

To create the database accounts in SQL Server 2005

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

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

  3. Repeat this procedure for all remaining accounts you must create.

To associate the database accounts together with the database roles in SQL Server 2005

  1. On the design-time computer that is running SQL Server, in SQL Server Management Studio expand <server name>(Windows NT), expand Security, expand Logins, right-click the database account, and then click Properties.

  2. In the Login Properties <account name> 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.

  4. In the Database role membership for <database name> box, select the check box for the appropriate role on the database, and then click OK.

  5. Repeat steps 3 through 6 until all the required accounts are associated with the specified database roles, and then click OK.

Note

You must be on the active node of a SQL Server Cluster to change the settings for accounts and roles.

See Also

Other Resources

Building the Staging Environment

Building an Enterprise Deployment

Granting Access to the Commerce Server Databases

What Database Access Permissions Must You Grant to CSS Authentication Accounts?

Configuring Security for Commerce Server Staging

What are the Staging Security Configuration Requirements?