Using SQL Authentication with the Retail2002 Site

The International Retail site was designed to work with Passport and SQL Authentication. As such, it is not currently compatible with Windows Authentication. If you have installed Commerce Server 2002 using Windows Authentication, a default installation of the International Retail Site will not function correctly. While you could rework the International Retail Site to support Windows Authentication, doing so would require major changes to the site architecture.

To ensure that the International Retail Site works correctly with SQL authentication, make sure the connection strings that the site uses to connect to resources use Microsoft SQL Server user accounts. If you modify the connection strings after you unpack the site, the site will not work correctly.

You must also assign the ASPNET user account to the database role with appropriate access. The ASPNET account is a local account on the Web server. You can use the dbowner role, but to improve site security you should choose a role that enables you to assign more specific permissions. The role you select depends on the configuration of your site. For more information see Securing Your Site.

Copyright © 2005 Microsoft Corporation.
All rights reserved.