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 2008 Additional Named Instance Server Build

Automated installation of a SQL Server 2008 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 2008 Additional Named Instance Server Build

The following steps show what you would have to do to install SQL Server 2008 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:

2) The SQL Server Installation Center is displayed. Click on Installation.
3) The following window is displayed. Click on New SQL Server stand-alone installation... to continue.
4) The Setup Support Rules are processed. All rules should succeed without any warnings or skipped rules. Click OK to continue.
5) The Setup Support Files window is displayed. Click Install to continue.
6) The Setup Support Rules are run and the results displayed.

- If your machine is not connected to the internet you will see the Microsoft .NET Application Security warning.
- If Windows Firewall is enabled you will see the Windows Firewall warning.

Both these warnings can be ignored. Click Next to continue.
7) The Product Key window is displayed. Enter the product key and click Next to continue. The 25 character Product Key should be held in the DBA Password Store.

If no product key is given, the Enterprise Evaluation Edition will be installed.
8) Accept the License Terms. Click Next to continue.
9) Select the components to be installed:

- Database Engine Services
- SQL Server Replication
- Full-Text Search
10) Specify the Instance Name. For this example, an instance called HR will be installed. Set the following values, and then click Next to continue.

Named Instance HR
Instance ID HR
Instance Root directory E:\Program Files\Microsoft SQL Server\

11) The Disk Space Requirements are displayed. Click Next to continue.
12) The Server Configuration window is displayed.
13) Using the Service Accounts tab, specify service accounts and passwords for each of the services in the top box.

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.
14) Select the Collation tab, and click the Customize... button.
15) Specify the Collation Setting.

If the SQL instance will be used to host databases that mainly use a single byte character set, for best performance specify the SQL collation sequence ‘Dictionary order, case insensitive, for use with 1252 Character set’. If databases will mainly use double-byte character data, or if data will regularly be passed from SQL Server to Analysis Services, then performance will be improved by using the Windows collation ‘Latin1_General’.

Click OK to continue.
16) The collation settings are confirmed. Click Next to continue.
17) The Database Engine Configuration window is displayed.

Using the Account Provisioning tab, set the Authentication Mode. Windows Authentication Mode should be used unless requested otherwise.

Click on the Add.. button.
18) Use the process Find Group on Domain with the DBA System Administration Group to configure Administration Account provisioning.

19) Click on Add Current User, to allow configuration of SQL Server during the install process.
InstallationCentre DBCurrentUser.png
20) Using the Data Directories tab, set the location of the SQL Server data files:

Data root directory E:\Program Files\Microsoft SQL Server
User database directory J:\SQLFiles\MSSQL.HR.Data
User database log directory K:\SQLFiles\MSSQL.HR.Log
tempdb directory T:\SQLFiles\MSSQL.HR.Data\Tempdb
tempdb log directory K:\SQLFiles\MSSQL.HR.Log\
Backup directory I:\SQLFiles\MSSQL.HR.Backup\AdHocBackup

InstallationCentre DBFolders.png
21) Using the FILESTREAM tab, specify the Filestream options. Click Next to continue.

Enable FILESTREAM for Transact-SQL access Checked

InstallationCentre DBFilestream.png
22) Specify Error and Usage Report settings. All checkboxes should be clear. Click Next to continue.
InstallationCentre EandR.png
23) The Installation Rules window is displayed. All rules should be successful, with no warning or skipped rules. Click Next to continue.
InstallationCentre InstallRules.png
24) The Ready to Install window is now displayed. Click Install to continue.
InstallationCentre Ready.png
The Installation Progress window is displayed. Various messages may be displayed in this window.
InstallationCentre Progress.png
25) Eventually the Setup will complete.

Check that all components have a green tick to indicate a completed install, and that the Status of each component is Success. Click Next to continue.
InstallationCentre Summary.png
26) The Complete window is eventually displayed. Click Close to continue.
InstallationCentre Complete.png
Copyright © 2011 - 2013 Edward Vassie. License and Acknowledgements
Previous Install SQL Server Top Install SQL Post Install Tasks Next

Last edited Aug 21, 2014 at 12:22 PM by EdVassie, version 9