SQL Server 2008 Installation Guide
Server: Windows Server 2008 [Spun up on a VPC with 1.5 G RAM] on a Lenovo Thinkpad T61P with 3 G RAM
· 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
1. Pre Setup and Configuration Steps
2. Setup and Configuration Steps
3. Post Setup and Configuration Steps
Pre Setup and Configuration Steps
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.
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
10. You will be prompted to restart your Server again. Click “Restart Now” to continue
Setup and Configuration Steps
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”
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.
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.
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.
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”
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.
12. I will present two options although I only performed the latter.
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”.
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…
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
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.
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”
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.
25. You have just Successfully Installed SQL Server 2008. Next the Post Setup and Config Steps.
Post Setup and Configuration Steps
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