SQL Server 2005 Installation.

1. SQL Server 2005 Installation

1. Install SQL Server 2005

With the SQL Server 2005 install disk 1 loaded, from the Start menu under “Install”, select “Server Components, tools, Books Online, and samples”.

[pic 1]

Review the End User License Agreement and check Accept and Next if you plan to continue with the installation.

[pic 2]

The setup program wizard will determine what prerequisites are required and prompt to install them…

[pic 3]

[pic 4]

[pic 5]

[pic 6]

[pic 7]

[pic 8]

[pic 9]

[pic 10]

On the following dialog, select all options and press Advanced…

[pic 11]

[pic 12]

[pic 13]

[pic 14]

[pic 15]

[pic 16]

[pic 17]

[pic 18]

Select the Local System account or preferably the assigned Domain Service Account (e.g. AMER\SRVMOP-PFIND-IT)

Select SQL Server Agent, Analysis Services, Reporting Services, and SQL Browser  to start at then end of setup.

[pic 19]

Use both the Windows Authentication and SQL Server Authentication modes.  Use an appropriate password for the “sa” account.

[pic 20]

For Collation Settings, SQL Server Setup will suggest the default collation based on the locale of your Windows server.  Please use the value suggested by SQL Server Setup.

For US English Servers the default is:

 SQL collations - Dictionary order, case-insensitive, for use with 1252 Character Set.

[pic 21]

For the Report Server Installation Options, select the Install the default configuration option.

[pic 22]

Do not have any of the Error and Usage Report Settings selected.

[pic 23]

If the “Ready to Install” screen does not have following minimum components identified, then go back to select them.  Click on Install to continue.

[pic 24]

[pic 25][pic 26]

Check the setup error logs.

...