How to Install Microsoft SQL Server 2008 R2
Posted by Mehmet ÖZKAN on 13 January 2016 10:54:26

SQL Server Setup installs the following software components required by the product:

  • .NET Framework 3.5 SP1
  • SQL Server Native Client
  • SQL Server Setup support files

The first thing that happens when you launch the installation of SQL Server 2008 R2 is it checks for the proper framework.  if it is not installed, it will install it for you.  In my case, it adds .NET Framework 3.5 SP1

On the next screen, click Installation on the left to display the installation options.  We are then going to select New Installation or Add Features to an existing installation. 

On the Setup Support Rules you should be able to just click OK.  If you click Show Details it will look something like this…

Enter your product key then click Next

Accept the license agreement click Next

On the Setup Support Files click Install

On the Setup Support Rules screen, you can see that I have a couple warnings

  • The Firewall warning will be ignored as well.  I will go back and modify the firewall later.
  • I will just click Next and move on
  • On the feature selection, I am going to make many changes…

On the Installation Rules you can click "Show Details" if you like then just click Neximage

Next is the Instance configuration…

for this section, I am going to tell the installer to put my instance on my E Drive.

If you do not yet have an E drive defined you can add it on the fly.

On the Database engine configuration Page we have much to do…

  • On the Account Provisioning tab I am changing to Mixed Mode.  This gives me the capability to manage users from inside of SQL.  Without it users have to use Windows authentication.  Once you change to mixed mode you will need to put in a password for the “SA” account which is the internal SQL Administrator account.  You will need to use a complex password for this.  If you do not need mixed mode, you can just leave Windows authentication mode turned on.
  • Click “Add Current User” which add.

In the Reporting Services configuration, I will leave Install the native mode default configuration and then click Next

  • Almost done.  You can show the details on the Installation Configuration Rules if you like
  • All applicable tests should be passed so just click Next

On the Ready To install screen you can review your configuration and then just click Install

Then just let it chug for about 20 mins or so (depending on performance of your machine it could be longer)

We are done with the installation of SQL.  You may want to take a few minutes to read the supplemental information. 

Also notice that a log file was left on the system in case you want to refer to it. When finished, you can just click  Close. 

You probably still have the SQL Server Installation center open.  You can close that by clicking the  X  in the upper right corner.

(1 vote(s))
This article was helpful
This article was not helpful

Help Desk Software by Kayako case