Installation of SQL Server 2008 R2
Mon, 11 Aug 2014

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users

1.Insert windows 2008 r2 CD

2. double click on Run SETUP.EXE

3. Accept user account control

download prerequisite Microsoft.NET Framework

Accept terms of licence agreement

Click install

Click exit

Another Pop up will display windows update standalone installer 

Hotfix for windows (KB942288)

Click OK

Restart the system if promted

Run the setup again after restart

Click installation

double click New installation or add features to an existing installation

Setup support rules page

Click Next

Input your product key

Click Next

Accept licence terms

Click install for setup support files

Correct Errors

and Click Next

Select SQL Server feature installation

and click Next

select all or select some of the features

click next

Click Next for installation Rules

An instance is either the default, unnamed instance, or it is a named instance. 

A named instance is identified by the network name of the computer plus the instance name that you specify during installation. The client must specify both the server name and the instance name when connecting.

By default, SQL Server installs in the default instance unless you specify an instance name. SQL Server Express, however, always installs in a named instance unless you force a default installation during setup.

Select Named Instance

Type in LOCALHOST

Or Select Default Instance

Click next

Disk space requirements

click Next

Select an account name

Click next

Select Mixed Mode

specify password for SA

Add current user

Analysis Services Configuration

Add current user

Reporting Services Configuration

select install native mode default Configuration

Click Next

Installation Configuration Rules

Click Next

Ready to install

Click Next

Installation Progress

Click Close

SQL server Installation Complete

comments powered by Disqus