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.
.gif "Important note") Important 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
Disconnect each server from any external network by unplugging all cables or disabling all network adapters.
Verify that the server that is running SQL Server is turned on.
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.
In the Microsoft SQL Server 2005 Enterprise Edition splash screen, under Install, click Server components, and tools.
On the End User License Agreement page, accept the terms of the license, and then click Next.
On the Installing Prerequisites page, click Install.
SQL Server 2005 Setup installs the required software components.
On the Installing Prerequisites page, click Next.
On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.
On the System Configuration Check page, click Next.
On the Registration Information page, enter information in the Name and Company boxes. To continue, click Next.
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
Click Next.
On the Instance Name page, select Default instance, and then click Next.
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.
In the Start services at the end of setup section, select all the check boxes, and then click Next.
On the Authentication Mode page, select Windows Authentication Mode, and then click Next.
On the Collation Settings page, select SQL collations, and then click Next.
On the Report Server Installation Options page, select Install the default configuration, and then click Next.
On the Error and Usage Report Settings page, select both check boxes, and then click Next.
On the Ready to Install page, click Install.
On the Setup Progress page, click Next.
On the Completing Microsoft SQL Server 2005 Setup page, click Finish.
See Also
Other Resources
Configuring the Database Servers