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!

Allow Windows Update to do more than just Windows

I like to have updated software on all of my computers.  Everything from patches to bug fixes are very important to my security profile.  Thus I allow Microsoft to update more than just Windows when I activate the Windows Update feature.  Here is a quick and easy way to activate that additional functionality.

image

image

image

image

Since I’ve never before given Internet Explorer to make changes to my system, a security popup has activated asking if it is ok… just hit yes.

image

Windows Update now starts it’s scan of additional software it has updates for…

Now wasn’t that easy…  Leave your comments and suggestions below!

Accessing SQL through the Windows Firewall

Recently I installed a new instance of SQL 2008r2.  (Get more details on installing Microsoft SQL Server 2008r2 here…)

Upon my arrival I quickly learned in order to allow applications to access the SQL server instance I needed to open up the following port on my windows firewall:  1433

So here goes…

 

image

image

image

image

image

image

image

image

image

image

image

The Microsoft article described a way to do this via an admin command prompt. I chose the graphical process.

If you have your firewall configured for outbound filtering as well, you may need to follow this process for under outbound filters as well.

Do you have an alternative way of configuring SQL for firewall access?  I’d love to hear from you… leave your comments below with your process or comments/suggestions on my process.