SQL Server 2008 Installation Guide


SQL Server 2008 Installation Guide

My Environment

Server: Windows Server 2008 [Spun up on a VPC with 1.5 G RAM] on a Lenovo Thinkpad T61P with 3 G RAM

The Build
Pre-Requisites

· To see the Hardware and Software Requirement please visit http://technet.microsoft.com/en-us/library/ms143506.aspx#EE32

· In my environment I had already installed Windows Server 2008

o Applied the following Roles

§ Web Server

§ Application Server

Steps

1. Pre Setup and Configuration Steps

2. Setup and Configuration Steps

3. Post Setup and Configuration Steps

Pre Setup and Configuration Steps

1. Attach you CD ISO Image or Insert you CD/DVD Media into the Drive Bay. An auto-run will ensue and you will be presented with this screen
clip_image002

2. Click “Run SETUP.EXE”. Next the setup will inspect your system for the .NET Framework 3.5 with SP1. Failing that check, it will ‘attempt’ to install it for you. In my installation it failed as you will see below; however mitigation steps are included.
clip_image004

clip_image006
clip_image008

3.

Setup may fail here indicating that it cannot install .NET framework until .NET 2.0 SP1 is

installed. that is bogus. .NET 2.0 SP1 is installed with BASE windows 2008 and when

you install the roles of Web Server and Application Server .NET 3.0 is installed.

However, to overcome this, go the the directory below manually and install .NET 3.5 SP1

Indicate that you have read and Accepted the terms of the License Agreement and click “Install”
clip_image010

4. When you inspect the error you will see the below item.
clip_image012

5. Navigate to you Windows Explorer and double click the file “dotNetFx3Setup”
clip_image014

6. Microsoft .NET Framework 3.5 SP1 Setup will execute and upon a successful installation of .NET Framework you will be presented with the following screen
clip_image016

7. Then you will be prompted to Restart your Server
clip_image018

8. Once you have rebooted and you are on your desktop, restart Setup from your ISO or CD/DVD Media. You will now be prompted to install a Hotfix for Windows.
clip_image020

9. Click “OK”, once you have done that the hotfix will install automatically and the following two screens will appear during the process and if the result was successful.
clip_image022
clip_image024

10. You will be prompted to restart your Server again. Click “Restart Now” to continue

Setup and Configuration Steps

1. Once you have rebooted and you are on your desktop, restart Setup from your ISO or CD/DVD Media. You will be presented with a Wizard Popup as indicated below
clip_image026
clip_image028

2. Setup will perform an inspection of your Hardware, Operating System , and File System and Registry. If successful, you will see the screen below.
clip_image030

3. You may need to click "Show Detail" displayed as "Hide Detail" in my screen shot to verify what was checked, and if an error was thrown you would click the link under the status section. Furthermore, you may review a detailed report by clicking on the link labeled “View Detailed report”
clip_image032

4.

NB. If you remove the License Key from the box Ctrl-C or X you will not be able to paste it back.

Click “OK” to continue and the SQL Installation wizard will continue. Next a Key will be present based on your Licensing Model with Microsoft, I removed CDW’s in the event this document is used for external purposes.
clip_image033
clip_image035

5. Click “Next”. You will then be presented with the License Acceptance Dialog Box
clip_image037

6. Select the checkbox and click “Next”. The next process will begin the launch of SQL Server 2008 Setup Support Files.
clip_image039

7. Once the checks have completed click Install and if any errors or warning were experienced you will be presented with a report to remediate the issues. In my installation, I am on a Microsoft VPC Image, the NICS are not Public Facing and I hard coded my IP on an internal address. I received two warnings one of which is as a result of my own configuration; the other is based on Windows Default Configuration. Your own situation may be different.
clip_image041
clip_image043
clip_image045

8. Click “Next” after you have remediated your issues, or choose to ignore them as I did. You will then be presented with the “Feature Selection” dialog box. Select the Server options you desire for this installation of SQL Server 2008 and click “Next”. By Default it is Blank none is selected, but I will load mine to the hilt.
clip_image047

9.

This is not where your Databases will live you will configure those options later on.

The next window presented will permit you to define your “Instance of SQL Server”, you may elect the “Default” instance if this is you first server instance or create a “Named Instance” if your situation merits. You may also change the Instance ID or accept the default and you may also configure where your Installation and “Root” files will live. Click “Next”
clip_image049

10. SQL Server will inspect your options and validate the space requirements based on your selection and return any miss-configurations to you if any. Assuming none, Click “Next”.
clip_image051

11. You will now configure your Server “Administrative and Services” Accounts. It is at this time if you were following best practice you would just select the User Accounts already created; but if you are like me, you will need to create them now. You may, as I elected to create one service account for all services so I don’t have to remember as many username/password combinations. Click Next once you have provisioned the credentials.
clip_image053
clip_image055

12. I will present two options although I only performed the latter.

a. If you choose to select a separate credential for each service you will have to click nect to the account name dropdown and browse for your account.
clip_image057
clip_image059

b. If you elect to use the same account for all your services then once you select that button, then you will see a this dialog box below
clip_image061

13. Select or Browse for your credentials and supply the password, Click “OK” when finished.

14. Once completed you will be presented with a window similar to the one below. Confirm and then you may select the “Collation” tab if you are concerned with the case sensitivity of your Database entries or Language concerns. If not, leave the defaults and Click “Next”.
clip_image063
clip_image065

15. The “Database Engine Configuration” dialog box is presented next. Here you will determine if you will use “Windows Authentication” or “Mixed Mode” for your End User and code interaction with this SQL Instance. Furthermore, with SQL Server 2008 you can now include additional SQL Server Administrators right from this menu. Very Cool! Click the “Database Directories” Tab and here is where you will…
clip_image067

16.

This article does not discuss the provisioning of File Groups, RAID, SAN, or other disk provisioning methods. I just selected the default, not recommended for Production

Configure the locations of the System Databases and mentioned earlier in step 9.
clip_image069

17. You may also select the “FILESTREAM” Tab, but I don’t know what that does yet.
clip_image071

18. If you selected “SQL Server Analysis Service” [SSAS] then here is where you would need to configure Account and Directory Information as we did for the Server Engine above. Click the “Data Directories” Tab to determine the location of SSAS files.
clip_image073
clip_image075

19. After you click “Next”, you will get to the screen I have been waiting for, the NEW Reporting Services of SQL Server specifically configured for Microsoft Office SharePoint Server…and other options. Make your selection for Default, SharePoint or no configuration of the Reporting Service. Click “Next”
clip_image077

20. The “Error and Usage Reporting” Dialog box is presented next. Select your options and click “Next”.
clip_image079

21.

To get a detailed report go here: C:Program FilesMicrosoft SQL Server100Setup BootstrapLog20080821_205927SystemConfigurationCheck_Report.htm

Once you have completed that step, you are almost there and now the SQL Installer will verify and validate your selections and options as denoted below. As usual you may show or hide the report and/or view a detailed Web report. Click “Next” when you are or have satisfied the selections.
clip_image081

22. The final screen before SQL Server takes over and commits the install is another verification screen or a “Last Chance” if you will, Click “Install” and you are on you are ‘Bolt-ing’ on your way.
clip_image083

23. This part is the longest, for my install it took over 35 minutes to complete, but if you are successful, you will be presented with a continual progress screen and eventually a success screen.
clip_image085

24. As the process winds down to a close, another progress wizard dialog box will appear and then…
clip_image086
clip_image088
clip_image090

25. You have just Successfully Installed SQL Server 2008. Next the Post Setup and Config Steps.

Post Setup and Configuration Steps

1. Verify and Validate your Services by selecting the “SQL Server Configuration Manager” in Program Files à SQL Server 2008. Make sure the service that should be running are running.
clip_image092

2. Verify and Validate that the Protocols that should be operational are operational
clip_image094

3. Log on and Verify that you can use the new Management Studio
clip_image096

4. Verify and Validate your System and User Databases
clip_image098

5. Check your SQL Instance Properties. Right Click on the Server Instance and Click Properties
clip_image100

6. Good Luck Hope this Helps! SQL 2008 ROCKS! For comments or questions please feel free to contact me. Fabian Williams – Fabian.Williams@CDW.com

Leave a comment

Your email address will not be published. Required fields are marked *