Installing SQL Server 2008 R2

SQL Server 2008 R2 Installation

  1. Run the setup.exe of your SQL Server 2008 R2 x64 installation DVD.
  2. Click “Installation” (on the left side).
  3. Click “New installation or add features to an existing installation“. 
  4. Setup Support Files screen: Click OK.
  5. Product Key screen: Enter the product key for the version of SQL Server 2008 R2. I usually install the Standard version. Click Next.
  6. License Terms screen: Click Next.
  7. Setup Support Files screen: Click Install.
  8. Setup Support Files screen: You may see some warnings.  You can ignore the Windows Firewall and Computer Domain Controller warnings since this is for a development environment. Click Next.
  9. Setup Role screen: Select SQL Server Feature Installation. Click Next.
  10. Feature Selection screen:
    1. Select the “Database Engine Services” feature.
    2. Select the “Management Tools – Basic” feature. The Management Tools – Complete will auto select. Click Next.
  11. Installation Rules screen: Confirm thre are no Failed or Warning items by clicking the Show details button. Click Next.
  12. Instance Configuration screen: Keep the Default instance selected, click Next.
  13. Disk Space Requirements screen: After validating the hard disk requirements, click Next.
  14. Server Configuration screen: Click “Use the same account for all SQL Server services”.
    1. Enter your SQL Service domain account.
    2. You don’t need to change the default collation settings given by the installation wizard.
    3. Click Next.
  15. Database Engine Configuration screen:
    1. Select “Windows Authentication”.
    2. Click “Add Current User” as a SQL Server administrator. Or, add any additional user accounts you want to have DB admin rights.
    3. Click Next.
  16. Click Next a few times and then click Install to start the installation.

SQL Server 2008 Configuration

  1. Open SQL Server Configuration Manager.
  2. Expand  the SQL Server Network Configuration node.
  3. Select the Protocols for MSSQLSERVER node.
  4. You have to enable “Named Pipes“.
  5. Restart your computer.
Advertisements

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