Installing Microsoft SQL Server 2008r2


I often find myself having to reinstall software.  I liked the way I installed it last time, but over time something occurred that required a reinstallation.  I don’t have instant recall on a lot of things… thus like much of my blog, I generate articles which assist me in the future.   This article relates to the installation of Microsoft SQL Server 2008r2. 

This outlines how I install this application within my personal test environment.  If you have alternative ways I would love to hear about them in the comments section of this post. 

Not all screen shots have comments, but a few do that require additional explanations.

12-2-2011 1-39-02 PM

12-2-2011 1-39-42 PM

12-2-2011 1-40-06 PM

12-2-2011 1-44-22 PM

12-2-2011 1-45-24 PM

12-2-2011 1-45-41 PM

12-2-2011 1-46-44 PM

12-2-2011 1-47-02 PM

12-2-2011 1-47-16 PM

12-2-2011 1-47-28 PM

12-2-2011 1-47-50 PM

12-2-2011 1-48-04 PM

I try to leave the firewalls on within my environment in order to promote good security practices.  MS SQL warns me whenever the firewall is on and directs me to a website with details on SQL’s firewall requirements when accessing the server from other systems.  (http://go.microsoft.com/fwlink/?LinkId=94001)

12-2-2011 1-48-39 PM

When I visit the link, I find I will need to configure the windows firewall to poke a hole for SQL.  Read my SQL Firewall article for details on doing this.

 

12-2-2011 1-50-32 PM

12-2-2011 1-54-16 PM

12-2-2011 1-54-52 PM

12-2-2011 1-55-08 PM

12-2-2011 1-55-59 PM

12-2-2011 1-57-03 PM

All of my special services are configured with extremely limited domain accounts.  Thus I needed to specify which account the SQL instances will run as.  They are specified here.

 

12-2-2011 1-58-02 PM

I wanted to allow both Domain and Local logins for my SQL server.  Thus I set it up with Mixed mode, configured an “SA” account password and added my domain account to the list of administrators of the DB server.

 

12-2-2011 1-59-55 PM

In the future I want to create a virtual SQL cluster.  In order to pre-plan for that I needed to put the database onto a separate vhd drive.  Thus I setup a separate vhd, mounted it via vSCSI and mounted it as the E:\ Drive.  Now This step shows pointing the database’s “data” drive at this new E:\ drive location.

 

12-2-2011 2-00-33 PM

12-2-2011 2-00-59 PM

12-2-2011 2-01-15 PM

12-2-2011 2-01-50 PM

12-2-2011 2-02-22 PM

12-2-2011 2-12-38 PM

 

Now that the base installation is complete, I need to patch-the-hell out of it.  A quick browse of Google and I find that SQL 2008r2 has a published Service PackI wrote a step-by-step guide for installing SP1 here

Leave your comments or suggestions below!

Advertisements

3 thoughts on “Installing Microsoft SQL Server 2008r2

  1. Pingback: Upgrading Servers with Microsoft SQL 2008r2 « DanielHeth’s Blog
  2. Pingback: Installing Tivoli Endpoint Manager (BigFix) v8.2.1093 « DanielHeth's Blog
  3. Pingback: bigfix.me | blog | Installing Tivoli Endpoint Manager (BigFix) v8.2.1093

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s