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!
