SQL Server 2008 R2: Install the SQL Client
In this article, let us look at the steps involved in installing SQL Server 2008 R2.
In order to have a smooth installation, restart the PC before beginning the SQL Server client installation. If the pc has a pending reboot, it would throw out a request to reboot in the middle of the installation, at that point you will have to reboot the machine and again restart from this step…
Start by double-clicking setup.exe in the installation folder of SQL Server 2008 R2.
You should see a popup window like below.
http://learnsqlwithbru.com/wp-content/uploads/2010/09/Client1.png
In the initial screen, you will find that the Planning section is bold (chosen) be a default (look in the left side section), click on Installation.
The picture below shows the screen when you click on installation**.**
http://learnsqlwithbru.com/wp-content/uploads/2010/09/Client2.png
Once you are in the Installation page, look at the first option from the top; New installation or add features to an existing installation. It goes to the next screen (shown below) which does few initial checks before starting the installation. Warnings can be ignored (it may not be a mandatory setting). If you find any failures, try to address them (you can know more info by clicking the Show details button). Click OK.
http://learnsqlwithbru.com/wp-content/uploads/2010/09/Client3.png
In the next step, you need to enter the Product Key found on your installation media. Click Next to continue.
In the License Terms screen, select the option against “I accept the license terms”. Click Next. (Image below)
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client5.png
In the Setup Support Files step, click the Install button. (Image below)
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client6.png
It would then install a series of support files that are required for the setup to continue installing.
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client7.png
The above image shows the same screen after the setup support components are installed. Again ensure that you do not have any failures, warnings can be ignored. Continue the installation by clicking Next.
In the Setup Role step, choose SQL Server Feature Installation. This option presents the opportunity to choose what components need to be installed, so a custom list of components can be chosen. Click Next to continue.
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client8.png
In the next screen, do not select anything under Instance Features. Only the Shared Features listed below should be selected.
- Client Tools Connectivity
- Client Tools Backwards Compatibility
- Client Tools SDK
- SQL Server Books Online
- Management Tools – Basic (Including the sub-selection of Management Tools – Complete)
- SQL Client Connectivity SDK
- Microsoft Sync Framework
Click Next to continue…
It would perform a check for the installation rules and displays the results as shown below. Note that warnings might not stop the installation and you should be looking to see that there are no failures…
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client10.png
Click Next to continue…
The next step displays the disk space information such as how much disk space it needs to install the chosen components and how much disk free space available on the local disk..
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client11.png
Click Next to continue…
The next screen asks if you would like to send Error Reports automatically to Microsoft. It is not mandatory and the installation would be able to continue even if the option is unchecked….
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client12.png
Click Next to continue…
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client13.png
In the Installation configuration rules, ensure that there are no failures and click Next to continue
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client14.png
This is the summary step, displaying the features you have chosen to install… Continue to the installation by pressing the Install button..
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client15.png
Installation continues depending on the number of components we have chosen and the system configuration where you are performing the installation.
http://learnsqlwithbru.com/wp-content/uploads/2010/12/2008R2Client16.png
This is the screen that displays that the installation was successful, the clock on Close button to finish the installation.