Installation SQL Server 2008 Manual / Automatic

Post date: Oct 16, 2010 9:21:06 PM

Introduction

This post is here to provide a canvas for SQL Server 2008 installation , it fit most of the installation need. and describe brief information on every step on what option to select and why.

We take two perspective in this post the manual installation , step by step with print screen and the automatic installation process with a configuration template file where you specify the default directories and account name and password.

Please note that I for all account names and password are virtual and use only as illustration. It will be up to you to set the values according to account credential that fit the best for your business.

Pre-Requisites

New local admin account

account name : dbadmin

account password : YourStrongPassword

Installation Process

As for advise, If anything goes not as indicated, or an error occur during the installation process. Make sur to transfer the information to the person in charge in your organisation.

Manual Installation Step by Step

Step 1

*

Note : Select the setup exe on the root folder, depending on your os subsystem it will know to run the x64 or x32 bits installation process

.

Step 2

Note : Select the “Installation” menu item on the left panel, then select the “New SQL Server Stand-alone installation or add features to an existing installation” menu item on the right panel

Step 3

Note : make sure to have all support requirements checked

.

Step 4

Note : the evaluation key will come automatically as this is a developer edition , just hit next button .

Step 5

Note : click the checkbox “I accept the license terms” option and hit next

.

Step 6

Note : at this stage , sql server will prompt you to install any requirements files missing , just hit install button

.

Step 7

Note : at this stage make sure that all support rules are checked and hit the next button

Step 8

Note : at this stage hit Select All button. and then the next button.

Step 9

Note : make sure you select the “default instance” radio button and that you have the instance id set to MSSQLSERVER

Step 10

Note : Space requirements step make sure you have all the requirements set and hit the next button

Step 11-1

Note : Set all account credentials to the dbadmin credential , please refer to Manual Installation / Pre Requisites for details. Choose the startup-type according to the print-screen, Then proceed to the Collation Panel.

Setp 11-2

Note : at the Collation Panel you will need to change the Database Engine and Analysis Services to the collation Latin1_General_CI_AI in order to do so please follow steps indicated on the following print-screen

Step 11-3

Step 11-4

Step 11-5

Note : when both collation are correctly set you can hit the next button

Step 12-1

Note : at this stage you want to set the authentication mode to Mixed Mode. the Password for the system administrator account will be initially set to “YourStrongPassword”. After you will proceed and select dbadmin account as part of the SQL Server administrators. Once this is done you can select the Data Directories panel for advanced configuration

Step 12-2

Note : by default this can stay as it is unless we have setup the disksubsystem otherwise (example in production for maximum performance we have separated the logs files from the data files and tempdb file is also splitted). Therefore this is to be confirmed everytime we setup a new sql server installation. Then proceed to the filestream panel.

Step 12-3

Note : make sure the FileStream option is not checked and hit the next button.

Step 13-1

Note : at this stage, include the dbadmin account as part of the of the users who have administrative permissions for Analysis services. and then select the Data Directories panel.

Step 13-2

Note : by default this can stay as it is unless we have setup the disksubsystem otherwise (example in production for maximum performance we have separated the logs files from the data files and temp files can also be splitted). Therefore this is to be confirmed everytime we setup a new sql server installation. Then you can hit the next button.

Step 14

Note : at this stage make sure to select the radio button Install the native mode default and then hit the next button

Step 15

Note : uncheck all checkboxes and then hit the next button

Step 16

Note : at this stage make sure all installation rules are checked and then hit the Next Button.

Step 17

Note : Review all the options and configuration options that you have selected during the installation process and then hit the install Button.

Step 18

Note : Let the system proceed with installation and ask for person in charge to test the installation

Automatic Installation

As an alternative to the manual installation the SQL Server installation can be achieved in command line simply using the steps described below :

  • Proceed to command line

  • Proceed to the root directory of the media/folder where is located the SQL Server binaries (e:\ in my case)

  • Type the command

    • Setup.exe /ConfigurationFile=c:\MSSQLSERVER_Installation_ConfigurationFile.ini /QUIET

  • At this point the installation will start in silent mode

    • if the installation succeeds you will have a brief information advising you about it

    • if the installation fails you will have the detailes on wich step and why,

      • in that scenario the report will have to be transmitted to the person in charge

Important Notes:

1. Make sure to change accounts name and password according to your business policy.

2. As for the manual steps described on the section Step 12-2 and 13-2 the configuration file may need to be updated with different data/log/temp locations drives and folder. This need to be addressed prior the installation within the configuration file.