Providing Access to Commerce Server Resources

  • Article

For Commerce Server Business Desk users and administrators to access resources, such as the Product Catalog, they must have sufficient permissions to access the SQL Server database that corresponds to the resource. A user should have a SQL Server login name that is linked to a SQL Server user that has the db_owner database role. Or, to provide more granularity, you can assign the user to the db_ddladmin, db_datareader, and db_datawriter roles.

To check the SQL Server roles assigned to a login name for a resource

  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, and expand the name of the database server containing the resource database you want.

  3. Expand Databases, expand the database corresponding to the resource you want, and then click Users.

  4. In the right pane, double-click the login name.

  5. In the Database User Properties dialog box, make sure the db_owner box is selected, and then click OK.

    Or, make sure the db_ddladmin, db_datareader, and db_datawriter boxes are selected, and then click OK.

Ee797382.note(en-US,CS.10).gifNote

  • You can also change these settings by modifying login properties in SQL Server Enterprise Manager. Expand the node for the database server you want, expand Security, and then click Logins to see the list of login names. Double-click a name to modify its database roles.

If the login name you specified does not appear in the list of database users, you can add a new SQL Server user.

To add a new SQL Server user for a resource database

  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, and expand the name of the database server containing the resource database you want.

  3. Expand Databases, expand the database corresponding to the resource you want, right-click Users, and then click New Database User.

  4. In the Database User Properties dialog box, do the following:

    Use this To do this
    Login name Select or type the login name used to access the database.
    User name Type the SQL Server user name that you want to assign to this login name. The user name assigns the new user permissions to objects in the database.
    Database role membership Select which roles the new user should have. Select the db_owner box to give the new user access to the resource. Or, select the db_ddladmin, db_datareader, and db_datawriter boxes.

  5. Click OK.


All rights reserved.