Setting up a trusted connection for Business Desk users

  • Article

When using Windows Authentication, you must trust the Commerce Server and the Web server on which the Business Desk application is installed for delegation. For instructions about trusting servers for delegation, see Step 5: Set up a Trusted Connection for Business Desk Users.

To change the anonymous account of the site to a domain account

  1. Before you perform these steps, create a user account on the Active Directory domain so that anonymous users can access SQL Server.

  2. In Commerce Server Manager, expand Internet Information Services, and then navigate to your application (for example, my_site).

  3. Right-click the application, and then click Properties.

  4. In the Properties dialog box, on the Directory Security tab, in the Anonymous access and authentication control section, click Edit.

  5. In the Authentication Methods dialog box, in the Anonymous access section, click Edit.

  6. In the Username box, type the name of a domain account.

  7. Click OK several times to close the dialog boxes.

  8. Click Start, and then click Run.

  9. In the Run dialog box, in the Open box, type iisreset, and then click OK.

    A command box appears while IIS is being reset. IIS is reset when the command box closes.

To assign the domain account permissions to SQL Server

  1. In Commerce Server Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand the server used by Commerce Server databases, and then expand Security.
  2. Right-click Logins, and then click New.
  3. In the SQL Server Login Properties - New Login dialog box, on the General tab, in the Name box, click Ellipsis to browse for and select the domain account.
  4. In the Domain box, type the name of the domain for the account.
  5. On the Database Access tab, select the Commerce Server databases to be accessed by this login.
  6. Click OK.

To change the connection string for the Administration database to SQL Server Authentication

  1. In Commerce Server Manager, right-click the node Commerce Server Manager, and then click Properties.

  2. On the Administration Database tab, click Modify.

  3. In the Data Link Properties dialog box, change the SQL Server name, if needed.

  4. To use SQL Authentication, select Use a specific user name and password, and then complete the User name and Password boxes.

    Ee798424.important(en-US,CS.20).gifImportant

    • Do not select Blank password. If you do, you will introduce a severe security vulnerability in your environment. It is also recommended that you do not use the sa account. Instead, create a new SQL account and assign it to the appropriate databases.

  5. Click OK.

Ee798424.note(en-US,CS.20).gif Notes

  • It is possible to add connection strings that are not associated with a database, and thus, do not work. If this occurs, Microsoft Data Link does not display an error message.
  • After you change a property in Commerce Server Manager, you must restart all services that use those values. For instructions, see Restarting IIS and Commerce Server Services.

Copyright © 2005 Microsoft Corporation.
All rights reserved.