This project has moved and is read-only. For the latest updates, please go here.

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

Install SQL 2005 Additional Named Instance Server Build

Automated installation of a SQL Server 2005 additional Named Instance server build is performed by Process Id 2BB.

The FineBuild additional Named Instance server build includes the following components:
  • SQL Server Database Engine
  • SQL Server Replication
  • Full-Text Search

Manual SQL 2005 Additional Named Instance Server Build

The following steps show what you would have to do to install SQL Server 2005 additional Named Instance for a server 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
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.
Wait while the installer starts…
4) Enter the Registration Information. The 25 character Product Key should be held in the DBA Password Store. Click Next to continue.
5) Select the components to be installed. Normally, select SQL Server Database Services only. Click Advanced to continue.
6) The Feature Selection window is displayed.

Ensure that the Installation paths are set to E:\Program Files\Microsoft SQL Server. Click Next to continue.
7) Specify the Instance Name. Select Named Instance and enter the instance name (in this example HR) in the box provided. Click Next to continue.
8) Ensure Customise for each service account is checked.
9) Select each service in turn and enter the Service Account Username, Password and Domain details for that service. The same account can be used for all services, but best practice is to use a separate account for each service so that the most appropriate security can be applied. Finally, click Next to continue.
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.
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_.
12) Specify Error and Usage Report Settings. All checkboxes should be clear. Click Next to continue.
13) The Existing Components window may be displayed.

If another instance already exists on the server, details of common components will be shown. Note that an upgrade of the displayed components is blocked if they have a build level higher than basic SQL Server 2005 install level.
14) The Ready to Install window is now displayed. Click Install to continue.
A number of information screens are displayed...
  • 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.
15) 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.
16) 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.
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 12:18 PM by EdVassie, version 8