How to Associate Database Accounts with Database Roles

How to Associate Database Accounts with Database Roles

Commerce Server 2009

This topic provides instructions for associating database accounts with database roles. 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 needed to perform their functions. The SQL Server roles are created for you during the unpacking of the site. 

For information about what SQL Login accounts you need to create on which computers that are running SQL Server, see Granting Access to the Commerce Server Databases. For information about the database role mappings you need to make, see What Are the Required Database Accounts and Database Role Mappings?

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

  1. On the design-time computer that is running SQL Server, click Start, point to All Programs, point to Microsoft SQL Server 2005 or Microsoft SQL Server 2008 (depending on the version you are using), 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, and then click Properties.

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

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

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


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

© 2016 Microsoft