Monday, October 15, 2012

SQL Server 2008R2 - Installation

So as we get started talking about installing and configuring the System Center 2012 Suite it occurs to me that we should take a step back and talk about setting up SQL. You will need to have it installed and configured correctly in order to use SC. So I am going to do my first segment on installing SQL 2008R2 and prepping it for SCOM (the next segment in the series).

You can download SQL 2008R2 Trial from the following locations if you don’t have access to a copy elsewhere.
x64 is the better choice in my opinion, unless you are installing SQL on an older box for testing there really isn't any reason to use the x86 version. I am going to install this on Windows Server 2008 R2 SP1 since that is the image I am currently working with in my lab.

Hardware/Software requirements:
A complete list of all of the hardware and software requirements can be found on the Microsoft Technet page. Please take a moment to review it to make sure you meet the minimum.

Prerequisite:
The only thing SQL Server 2008R2 needs prior to install is .NET 3.5

Open Server Manager
Click on Features
Click Add Features
Check the box for .NET Framework 3.5.1 Features
     You will be prompted to install Web Server (IIS) and Windows Process Activation Service
     Click Add Required Role Services to continue
     On Web Server (IIS) Click Next
     On Select Role Services Click Next
     On Confirm Installation Selections Click Next

Installation:
Once you have the install media, right click on setup.exe and run as administrator. This is important, if you don’t run as administrator you can run into permissions issues later!

When the SQL Server Installation Center opens up (Step 1) Click Installation on the left menu.
Step 1

On the Installation page (Step 2) Click New installation or add features to an existing installation.
Step 2

The installation will automatically go through the Setup Support Rules (Step 3). If everything passes, Click OK. Otherwise Click Show Details and resolve any issues outstanding.
Step 3

On the Product Key page (Step 4) select Specify a free edition, or enter a product key if available and Click Next.
Step 4
On the License Terms page Check I accept the license terms and Click Next
Step 5

On the Setup Support Files (Step 6) Click Install
Step 6
In step 7 the Setup Support Rules will run automatically to validate that all install issues are resolved. If they are Click Next, otherwise Click the Warning or Failed next to the error for additional details on how to resolve.
Step 7
On the Setup Role select SQL Server Feature Installation then Click Next
Step 8
In Step 9 Feature Selection, Check Database Engine Service, Full-Text Search, Reporting Services (I will be doing a follow up segment on configuring SSRS for SCOM later), Management Tools - Basic and Management Tools - Complete. Keep the default directories. Click Next
Step 9
Installation Rules will run again to validate any install issues. As before Click Next if everything is OK, otherwise Click Show Details
Step 10
In Step 11, for the sake of simplicity we are going to keep the default instance. This can be changed if you require another instance setup on the box you are working with. Click Next
Step 11
On Disk Space Requirements Click Next
Step 12
On Step 13, best practice dictates that you create unique service accounts for each of the SQL services running on the machine. For this example, however I am using Network Service since this is just a lab installation. Enter in the domain\username and password for each account and Click Next
Step 13
For Database Engine Configuration (Step 14) Select Windows authentication mode. For Specify SQL Server administrators, I always add domain\administrator (Administrator) to ensure access. Click Next
Step 14
In Reporting Services Configuration Select Install the native mode default configuration, since we are setting this up for System Center not SharePoint we don't need to create the database in SharePoint integrated mode. Click Next
Step 15
In Step 16 Error Reporting Click Next
Step 16
A final Installation Configurations Rules will run. Follow procedures as before. Click Next
Step 17
On Step 18 Ready to Install, review the setup information and Click Install. This is a good opportunity to go get some coffee. The install takes about twenty to thirty minutes (depending on the specs of the box) to complete.
Step 18
If we did everything correctly you will be greeted with the Your SQL Server 2008 R2 installation completed successfully page, shown below.
Success!

Click Close and you are all set!

No comments:

Post a Comment