Jaa


How to Install SQL Server 2005

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

This topic provides steps for installing Microsoft SQL Server 2005 Enterprise Edition on the database servers. If you are using Microsoft SQL Server 2000 Enterprise Edition, see How to Install SQL Server 2000. For more information about how to install SQL Server 2005, see https://go.microsoft.com/fwlink/?linkid=62409.

ms942986.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

Note

To configure a Data Warehouse server, see Configuring the Data Warehouse and Analysis Server.

To install SQL Server 2005

  1. Disconnect each server from any external network by unplugging all cables or disabling all network adapters.

  2. Verify that the server that is running SQL Server is turned on.

  3. Insert the SQL Server 2005 Enterprise Edition CD into the CD drive of the first server.

    If the Microsoft SQL Server 2005 Enterprise Edition splash screen does not appear, run the splash.hta file from the product CD.

  4. In the Microsoft SQL Server 2005 Enterprise Edition splash screen, under Install, click Server components, and tools.

  5. On the End User License Agreement page, accept the terms of the license, and then click Next.

  6. On the Installing Prerequisites page, click Install.

    SQL Server 2005 Setup installs the required software components.

  7. On the Installing Prerequisites page, click Next.

  8. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.

  9. On the System Configuration Check page, click Next.

  10. On the Registration Information page, enter information in the Name and Company boxes. To continue, click Next.

  11. On the Components to Install page, select the following options:

    For a production database server, select:

    • SQL Server Database Services

    • Notification Services

    • Integration Services

    • Workstation components, Books Online and development tools

    For a Data Warehouse and analysis server, select all the options. These include the following:

    • SQL Server Database Services

    • Analysis Services

    • Reporting Services

    • Notification Services

    • Integration Services

    • Workstation components, Books Online and development tools

  12. Click Next.

  13. On the Instance Name page, select Default instance, and then click Next.

  14. On the Service Account page, select Use a domain user account, and then do the following:

    Use this

    To do this

    Username

    Type SQLSvc.

    Password

    Type the corresponding password for this account.

    Domain

    Type the data domain name.

  15. In the Start services at the end of setup section, select all the check boxes, and then click Next.

  16. On the Authentication Mode page, select Windows Authentication Mode, and then click Next.

  17. On the Collation Settings page, select SQL collations, and then click Next.

  18. On the Report Server Installation Options page, select Install the default configuration, and then click Next.

  19. On the Error and Usage Report Settings page, select both check boxes, and then click Next.

  20. On the Ready to Install page, click Install.

  21. On the Setup Progress page, click Next.

  22. On the Completing Microsoft SQL Server 2005 Setup page, click Finish.

See Also

Other Resources

Configuring the Database Servers

Building an Enterprise Deployment

Deployment

How to Install SQL Server 2005 Service Pack 2