How to Create the Database Accounts

  • Article

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

This topic provides steps for creating database accounts in SQL Server for the Active Directory user or group accounts as described in What Are the Accounts and Groups to Create?. After you create these database accounts, you specify the database permissions for these accounts.

Create these database accounts on the SQL Server to create new logins in SQL Server for each user or group account.

To create the database accounts in SQL Server 2000

  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, expand <SQL cluster name>, expand Security, right-click Logins, and then click New Login.

  3. In the SQL Server Login Properties - New Login dialog box, on the General tab, in the Name box, type <domain name>\<account name>, and then click OK.

  4. Repeat this procedure for all remaining accounts you need to create.

To create the database accounts in SQL Server 2005

  1. Click Start, point to 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 SQL Server computer, expand Security, right-click Logins, and then click New Login.

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

  5. Repeat this procedure for all remaining accounts you need to create.

See Also

Other Resources

Building the Staging Environment

Building the Data Tier

Building an Enterprise Deployment

Granting Access to the Commerce Server Databases