Home > Installation, Troubleshooting > Today’s Lesson: Installation of SQL Server

Today’s Lesson: Installation of SQL Server

Today, we’ll discuss the preparations for the installation of SQL Server 2008 R2.  After opening the installation program, unlike most programs, you’ll be faced with a plethora of options and choices.  It can be daunting to someone new to SQL, and here I’ll do a quick walk through to get you started.

Before you begin the installation of Microsoft SQL Server 2008 R2 Express please ensure that:

  • You are logged in to Windows as Administrator or as a user with administrator permissions (for instructions refer to Windows help or documentation on Microsoft website, or contact your machine/network administrator),
  • All other programs in Windows are closed and not running (for instructions refer to your vendor’s documentation),
  • Your previous antivirus software is fully uninstalled (for instructions refer to your vendor’s documentation),
  • Microsoft Windows Installer 4.5 (or later) is already installed, because it’s required in order to install and run Microsoft SQL Server 2008 R2 Express. If not, you will need to download it from Microsoft website and install it on your machine.
  • Microsoft .NET Framework 3.5 Service Pack 1 (or later) is already installed, because it’s required in order to install and runMicrosoft SQL Server 2008 R2 Express. If not, you will need to download it from Microsoft website and install it on your machine.
  • Microsoft Windows PowerShell 1.0 (or later) is already installed, because it’s required in order to install and run Microsoft SQL Server 2008 R2 Express. If not, you will need to download it from Microsoft website and install it on your machine.

When you are ready, proceed as follows:

  1. Firstly download the Microsoft SQL Server 2008 R2 Express with Tools from the Microsoft website and save it to your machine (SQLEXPRWT_x64_ENU.exe for 64-bit editions of Windows, SQLEXPRWT_x86_ENU.exe for 32-bit editions of Windows).
  2. Run the downloaded setup file SQLEXPRWT_x64_ENU.exe (or SQLEXPRWT_x86_ENU.exe if 32-bit Windows edition is used). If you are logged in as a user with administrator permissions, right-click on the setup file and choose ‘Run as administrator‘ from the context menu.
  3. From the menu on the left side of the ‘SQL Server Installation Center‘ screen select ‘Planning‘ and then click ‘System Configuration Checker‘ on the right.
    Figure I. A
  4. The ‘System Configuration Checker‘ will just verify whether your machine meets a minimum system requirements to install Microsoft SQL Server 2008 R2 Express.
    Figure II.A

    If there will be some error or warning message displayed, please check the prerequisites mentioned above or refer to Microsoft SQL Server 2008 R2 documentation on Microsoft website for further instructions how to fix the issue:

  5. After successful verification, i.e. without any errors or warnings, select ‘Installation‘ from the menu on the left side of the ‘SQL Server Installation Center‘ screen and then ‘New installation or add features to an existing installation‘ on the right to invoke a setup process. Make sure there are no any other error or warning messages because the setup will check your configuration again.
    Figure III. A
  6. When the License Terms screen is displayed, read the license agreement, tick the checkbox ‘I accept the license terms.‘ and click ‘Next‘.
    Figure IV. A
  7. The Setup Support Files will be then installed and when it completes, the ‘Feature selection‘ screen will appear. Leave all default features selected or at least select ‘Database Engine Services‘ with ‘SQL Server Replication‘ and ‘Management Tools – Basic‘. You can also change shared feature directory, but leave it default, if possible, and click ‘Next‘.
    Figure V. A
  8. On the ‘Instance Configuration‘ screen select the option ‘Default instance‘ to automatically use the name MSSQLSERVER for the instance of SQL Server in both the ‘Named instance‘ and ‘Instance ID‘ fields. Then click ‘Next‘.
    Figure VI. A
  9. On the ‘Server Configuration‘ screen change the Account Name for the SQL Server Database Engine to ‘NT AUTHORITY\SYSTEM‘ and also Startup Type for the SQL Server Browser to Automatic, and click ‘Next‘.
    Figure VII. A
  10. On the ‘Database Engine Configuration‘ screen select ‘Mixed Mode (SQL Server authentication and Windows authentication)‘ to enter and confirm a password for the SA account. Also click ‘Add…‘ and specify the group that you want to have unrestricted access to SQL Server. You should add at least Administrator. Then click ‘Next‘ twice,
    Figure VIII. A

    …and once the installation progress completes, click ‘Close‘ to exit the SQL Server 2008 R2 Setup.

    Figure IX. A

Well, that about does it.  SQL Server with Management Studio is now installed on your computer.  Next time, we’ll discuss the import/recovery of databases as we install the AdventureWorks2008R2 database.  See you then!

Advertisements
  1. Ayodeji Oyenekan
    September 23, 2012 at 3:02 pm

    I just discover this website today and am loving it 🙂 Thanks for taking your time to teach people like me who are new to T-sql

  1. No trackbacks yet.

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

%d bloggers like this: