How to Grant Staging Accounts Access to the Databases

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

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

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

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?