Share via

How to Associate Database Accounts with Database Roles

  • Article

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

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

  1. On the design-time computer that is running SQL Server, 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, and then click Properties.

  4. In the SQL Server Login Properties <account name> dialog box, on the Database Access tab, in the top box, select a database.

  5. In the bottom box, specify the role for the account, and then click OK.

  6. Repeat steps 3 through 5 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.

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

  1. On the design-time computer that is running SQL Server, 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, 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.

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

What Are the Required Database Accounts and Database Role Mappings?

Granting Access to the Commerce Server Databases