This project has moved. For the latest updates, please go here.

Previous Install SQL Server Manual Install Install SQL Post Install Tasks Next

Install SQL 2005 Workstation Build

Automated installation of SQL Server 2005 for a server is performed by Process Id 2BB.

The FineBuild Workstation build includes the following components:
  • SQL Server Database Engine
  • SQL Server Replication
  • Full-Text Search
  • Analysis Services
  • Integration Services
  • Reporting Services
  • SQL Server Tools

Manual SQL 2005 Workstation Install

The following steps show what you would have to do to install SQL Server 2005 for a Workstation manually. FineBuild does all of this work for you automatically.

1) Start the SQL Server install. The following message is displayed:
Cannot resolve image macro, invalid image name or id.
2) The SQL 2005 Welcome window is displayed. Click Next to continue
InstallWelcome.png
3) The results of the System Configuration Check are displayed. It is expected that a warning message will be given for the IIS Feature Requirement. Click Next to continue.
  • If the install is being performed on a virtual guest machine, a warning will be given for Minimum Hardware Requirement, but this can be ignored.
ConfigurationCheck.png
  • Wait while the installer starts…
InstallerStart.png
4) Enter the Registration Information. The 25 character Product Key should be held in the DBA Password Store. Click Next to continue.
Registration.png
5) Select the components to be installed. For the default instance, all components are normally selected except for Reporting Services. Click Advanced to continue.
  • If IIS is not installed, it will not be possible to select Reporting Services.
  • Analysis Services is not included in an Express or Workgroup Edition install.
Components.png
6) The Feature Selection window is displayed…
FeatureSelection.png
7) Ensure that the Installation paths are set correctly:
For all top-level options E:\Program Files\Microsoft SQL Server
User database directory J:\SQLFiles\MSSQL.MSSQLSERVER.Data
Analysis Services Data Files J:\SQLFiles\MSAS.MSSQLSERVER.Data

FeatureSelectionPaths.png
Click Browse to change any of the installation paths.
PathBrowse.png
8) Specify the Instance Name. Normally the Default instance will be installed. Click Next to continue.
InstanceName.png
9) The Service Account window is displayed.
  • Ensure Customise for each service account is cleared. Verify all account names are set to Network Service and click Next to continue. The same account should be used for all services.
ServiceAccount.png
10) Specify the Authentication Mode. Windows Authentication Mode should be used unless requested otherwise. A random password will be generated for the sa account, which will be set to a known value in Configure SA Account.
AuthenticationMode.png
11) Specify the Collation Setting. Specify the use of the SQL collation sequence Dictionary order, case insensitive, for use with 1252 Character set. Click Next to continue.
  • If the SQL instance will be used to host databases that mainly use double-byte character data, then performance will be improved by using the Windows collation Latin1General_.
SQLCollation.png
12) Specify Error and Usage Report Settings. All checkboxes should be clear. Click Next to continue.
ErrorReporting.png
13) The Ready to Install window is now displayed. Click Install to continue.
ReadyToInstall.png
  • A number of information screens are displayed...
SetupProgress.png
  • Components are not installed in top to bottom sequence. Some components have multiple configuration stages. Wait until all components are installed and configured - this can take about 15 minutes.
SetupRunning.png
14) Eventually the Setup will complete. Check that all components have a green tick to indicate a successful install, and that the Status of each component is Setup finished. Click Next to continue.
SetupFinished.png
15) If desired, the Summary Log can be viewed. The Surface Area Configuration Tool will be run at a later stage in the install process. Click Finish to complete the install.
InstallComplete.png
Copyright © 2008 - 2014 Edward Vassie. License and Acknowledgements
Previous Install SQL Server Top Install SQL Post Install Tasks Next

Last edited Aug 21, 2014 at 10:28 AM by EdVassie, version 5