Jaa


How to Install SQL Server 2000

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

This topic provides steps for installing Microsoft SQL Server 2000 with Service Pack 4. For instructions about how to install Microsoft SQL Server 2005 Enterprise Edition, see How to Install SQL Server 2005.

For more information about how to install SQL Server 2000, see https://go.microsoft.com/fwlink/?linkid=62410.

ms943008.alert_caution(en-US,CS.70).gifImportant Note:

In order to function correctly, Commerce Server databases require case-insensitive collation settings. If you have configured SQL Server so that databases are created with case-sensitive collations by default, you will have to take extra steps to make sure that the Commerce Server databases are not created using your default collation settings. For example, you could pre-create the Commerce Server databases, and then use a command such as the following to change the default collation settings for these databases before running the Commerce Server Setup program:

ALTER DATABASE <database_name> COLLATE SQL_Latin1_General_CP1_CI_AS

To configure a non-clustered database server to run SQL Server 2000

  1. Install SQL Server 2000 on the database server. For instructions, see https://go.microsoft.com/fwlink/?LinkId=72004.

  2. Install SQL Server 2000 Service Pack 4. For instructions, see https://go.microsoft.com/fwlink/?LinkId=56730.

To configure a clustered database server to run SQL Server 2000

  1. Follow the instructions for creating clustered database servers. For more information, see https://go.microsoft.com/fwlink/?LinkId=71819.

  2. Install SQL Server 2000 on the database server. For instructions, see https://go.microsoft.com/fwlink/?LinkId=72004.

  3. Install SQL Server 2000 Service Pack 4. For instructions, see https://go.microsoft.com/fwlink/?LinkId=56730.

See Also

Other Resources

How to Install SQL Server 2000 Service Pack 4

Configuring the Database Servers

Building the Data Tier

How to Install SQL Server 2005