Share via

How to Install SQL Server 2005

  • Article

This topic provides procedures about how to install Microsoft SQL Server 2005 Enterprise Edition and Microsoft SQL Server 2005 Service Pack 2 on the database servers. For more information about how to install SQL Server 2005, see https://go.microsoft.com/fwlink/?linkid=62409.

Dd451948.alert_caution(en-US,CS.90).gifImportant Note:

In order to function correctly, Commerce Server 2009 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 2009 databases are not created using your default collation settings. For example, you could pre-create the Commerce Server 2009 databases, and then use a command such as the following to change the default collation settings for these databases before running the Commerce Server 2009 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.

To install SQL Server 2005 SP2

  1. Verify that the computer that is running SQL Server is on. If your deployment involves clustered computers that are running SQL Server, verify that both computers that are running SQL Server are on.

  2. In Internet Explorer, visit the SQL Server 2005 SP2 download page at https://go.microsoft.com/fwlink/?LinkId=87019.

  3. Follow the instructions to download the version of SQL Server that meets your business needs.

  4. Click Close when the download is completed.

  5. Click Start, click Run, type Explorer, and then click OK.

  6. In Windows Explorer, locate the folder where you saved the service pack Setup file, and then double-click the Setup file.

  7. Follow the prompts to install SQL Server 2005 SP2.

  8. On the Authentication Mode page, select Windows Authentication, and then continue with the installation.

  9. After the installation is complete, restart the computer.

See Also

Other Resources

Configuring the Database Servers

Building an Enterprise Deployment

Deployment