Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Wednesday, 10 June 2015

How to Install SQL Server 2008 R2 on Windows Server 2008 R2 ? List of Cumulative Update Package for SQL 2008 R2

How to Install SQL Server 2008 R2 on Windows Server 2008 R2 ?

Read more: http://www.mytechmantra.com/LearnSQLServer/Install_SQL_Server_2008_R2_P1.html#ixzz3cereKtI1 

Introduction

Microsoft SQL Server 2008 R2 Release to Manufacturing (RTM) was released in the April 2010. There are different versions of SQL Server 2008 R2 available such as Datacenter Edition, Parallel Data Warehouse Edition, Enterprise Edition, Standard Edition, Web Edition, Workgroup Edition, Developer Edition, SQL Azure, Compact Edition and Express Edition. You can download the trial version of SQL Server 2008 R2 from the following link. In this article we will take a look at how to install SQL Server 2008 R2 on a Windows Server 2008 R2 Server. However, the steps mentioned in this article can be followed while installing SQL Server 2008 R2 on Windows Server 2008.

Prerequisites for SQL Server 2008 R2

Microsoft SQL Server 2008 R2 requires Windows Installer 4.5 and .Net Framework 3.5 Service Pack 1 to be installed on the server. You can download Windows Installer 4 from the following link and you can download Microsoft .Net Framework 3.5 Service Pack 1 from the following link. Once you have installed the prerequisites you may be asked to restart the operating system.

Installing SQL Server 2008 R2

1. Database Administrator should log on to the server with administrative privileges and then right click Setup.EXE file and choose Run as administrator option from the drop down list as shown in the below snippet.
Run as administrator
2. As a Prerequisite SQL Server 2008 R2 setup will require Microsoft .Net Framework 3.5 SP1 and the latest version of Windows Installer 4.5 to be installed. You can install the same by clicking the OK button.
Prerequisite SQL Server 2008 R2 setup will require Microsoft .Net Framework 3.5 SP1 and the latest version of Windows Installer 4.5
3. In Windows Update Standalone Installer popup, click OK button to install Windows Installer 4.5. You can even install Windows Installer 4.5 by downloading it from the following link.
Prerequisite for SQL Server 2008 R2 Install Windows Installer 4.5 KB942288 

4. Once Windows Installer 4.5 is installed successfully the setup may ask you to restart the server. Once the server is up after the restart once again run the Setup.EXE file. This time setup will ask you to install .Net Framework 3.5 SP1 incase if it is not installed on the server. Once the installation of .Net Framework has completed successfully the SQL Server Installation Center will open up as shown in the snippet below. You need to navigate to the Options screen as shown in the snippet below to choose the appropriate Processor Type to specify the architecture of SQL Server 2008 R2 to be installed.
SQL Server 2008 R2 Installation Center
5. In SQL Server Installation Center’s Installation Screen you need to choose New Installation or add features to an existing installation option as highlighted to install a standalone instance of SQL Server 2008 R2
SQL Server 2008 R2 New installation or Add features to an existing installation screen

6. It will open up Setup Support Rules window which will identify problems that might occur when you install SQL Server Setup support files. You must correct the failures if there are any before the setup can continue. If there are no issues identified then click OK to continue with the installation.
SQL Server 2008 R2 Setup Support Rules screen
7. In Product Key window you can choose to install SQL Server 2008 R2 as an evaluation edition or else you can enter the Product Key to install the version specific to the Key. If you are installing the Evaluation Edition then you can upgrade to another edition using the Edition Upgrade Wizard. As like in SQL Server 2008 even SQL Server 2008 R2 also has a single installation for all editions of SQL Server 2008 R2. Once you have entered the Product Key or choose the free edition (Evaluation) then click Next to continue with the installation.
SQL Server 2008 R2 Product Key Screen
8. In the License Terms screen, you can go through the license agreement and then select the check boxes at the bottom of the screen to accept the license terms and conditions and then click Next to continue with the installation.
SQL Server 2008 R2 License Terms 

9. In Setup Support Rules screen it will identify problems that might occur when you install SQL Server Setup support files. In case if there are any issues identified then you need to fix the same before continuing with the installation. If you want to avoid getting Windows Firewall error then you can disable the windows firewall before the installation and enable the same once the installation is complete.
SQL Server 2008 R2 Setup Support Rules 

10. In Setup Role screen you can click the SQL server Feature Installation option to individually select which feature components to install or you can click a feature role to install a specific configuration. The different chooses available in this screen are:-
SQL Server Feature Installation: - Install SQL Server Database Engine Services, Analysis Services, Reporting Services, Integration Services and other features.

SQL Server PowerPivot for SharePoint: - Install PowerPivot for SharePoint on a new or existing SharePoint 2010 server to support PowerPivot data access in the farm. To use the New Server option, SharePoint must be installed but not configured.

All Features With Defaults: - Install all features using default values for the services accounts.

SQL Server 2008 R2 SQL Server Feature Installation option
In the above snippet you need to choose SQL Server Feature Installation option and click Next to continue with the installation.
11. In Feature Selection screen you need to choose the features which you would like to install. The different components which are available for installation with SQL Server 2008 R2 are:-

Database Engine Services: - Includes the Database Engine, the core service for storing, processing and securing data. The Database Engine provides controlled access and rapid transaction processing and also provides rich support for sustaining high availability. The Database Engine also provides support for the utility control point in the SQL Server Utility. Only Database Engine Services and Analysis Services can be clustered.

SQL Server Replication: - Includes the Database Engine, the core service for storing, processing and securing data. The Database Engine provides controlled access and rapid transaction processing and also provides rich support for sustaining high availability. The Database Engine also provides support for the utility control point in the SQL Server Utility. Only Database Engine Services and Analysis Services can be clustered.

Full – Text Search: - Includes the Full-Text Search engine, for fast text search on content stored in SQL Server.

Analysis Services: - Includes Analysis Services and tools used to support online analytical processing (OLAP) and data mining. Only Database Engine Services and Analysis Services can be clustered.

Reporting Services: - Includes Reporting Services, a server-based application for creating, managing, and delivering reports in paper-oriented and interactive Web-based formats. Reporting Services cannot be clustered.

Integration Services: - Includes the designer, runtime, and utilities that enable Integration Services to move, integrate, and transform data between data stores.

Shared Features: - Some shared features are shared across all versions of SQL Server on a computer. Shared features for a major release are used only by multiple instances of the same version of SQL Server; other features are shared only across minor version instances.

Redistributable Features: - SQL Server redistributable and shared features are installed when needed: Error and Usage Reporting, SQL Server Native Client, MSXML version 6.0, SQL Server Compact Workbench, SQL Server Compact Runtime, Sync Services for ADO.NET, and SQL Server Browser.
SQL Server 2008 R2 Feature Selection Screen, Database Engine Services, Analysis Services, Reporting Services, SQL Server Replication, Full Text Search
12. In Installation Rules screen the setup is running rules to determine if the installation process will be blocked. Click Next to continue with the installation.
SQL Server 2008 R2 Installation Rules 

13. In Instance Configuration screen you need to specify the name and the instance ID for the instance of SQL Server and click Next to continue with the installation.
SQL Server 2008 R2 Instance Configuration
14. In Disk Space Requirements screen you will be able to see the amount of disk space which is required for the installation of SQL Server 2008 R2. Click Next to continue with the installation.
SQL Server 2008 R2 Disk Space Requirement 

15. In Server Configuration screen you can specify the Service Account and the Collation. In the Service Accounts tab, you need to specify the Service Account under which SQL Server Services should be running. Here you can also specify the Startup Type for each of the SQL Server Services.
SQL Server 2008 R2 Server Configuration
In the Collations tab, you can specify the collation for Database Engine and Analysis Services or else you can leave the default values as per the operating system. Click Next to continue with the installation screen.
SQL Server 2008 R2 Server Configuration Collation Screen
16. In the Database Engine Configuration screen, you can specify authentication mode and administrators for the Database EngineData Directories and FILESTREAM.

In the Account Provisioning Tab you can specify the Authentication Mode. It is always a best practice to choose Mixed Mode (SQL Server and Windows Authentication). You can then specify the password for the SQL Server system administrator (SA) account and also add Specify SQL server administrators as shown in the snippet below.
SQL Server 2008 R2 Database Engine Configuration
In the Data Directories tab, you can specify the path of where user database data and log file should be stored. You can also specify the path where TempDB data and log file should be stored. It is always a good practice to store TempDB data and log file on different drives to improve performance. In this screen you can also specify the database backup directory as shown in the below snippet.
SQL Server 2008 R2 Database Engine Configurations Data Directories
In the FILESTREAM tab, you can configure the FILESTREAM feature of SQL Server 2008 R2. There are basically three different FILESTREAM configuration options such as:-
• Enable FILESTREAM for Transact-SQL access
• Enable FILESTREAM for file I/O streaming access; here you can specify the windows shared folder name
• Allow remote clients to have streaming access to FILESTREAM data.
SQL Server 2008 R2 Database Engine Configurations FILESTREAM Screen
17. In the Analysis Services Configuration screen you can specify the analysis services administrators and data directories. In the Account Provisioning tab you can specify which users have administrative permissions for Analysis Services


In the Data Directories tab, you can specify the Data directoryLog file directoryTemp directory and Backup Directory for analysis services. Click Next to continue with the installation.
SQL Server 2008 R2 Analysis Services Configuration Data Directories Screen 

18. In the Reporting Services Configuration screen there are three different choices available to specify the reporting services configuration mode.

Install the native mode default configuration: - Setup will install the report server and configure it in Native mode to use the default values. The report server is usable as soon as setup is finished.

Install the SharePoint integrated mode default configuration: - Setup will create the report server database in SharePoint integrated mode and configure the report server to use the default values. However, integrated operations will not be supported until a minimal installation of a SharePoint product or technology is deployed on the report server computer and the Reporting Services Add-in for SharePoint Technologies is installed and configured on the instance of the SharePoint product or technology you are using.

Install, but do not configure the report server: - Setup will install, but will not configure, the report server software. After installation is finished, you can use the Reporting Services Configuration tool to set options that are required to run the report server. 
SQL Server 2008 R2 Error Reporting Screen 

19. In the Error Reporting screen you can select the checkbox to automatically send logs to Microsoft to improve future releases. Click Next to continue with the installation.
SQL Server 2008 R2 Error Reporting
20. In Installation Configuration Rules screen the setup will run rules to determine if the installation process will be blocked. In case if there are any issues encountered then you need to fix the same before continuing with the installation.
SQL Server 2008 R2 Installation Configurations Rules

21. In Ready to Install screen you can quickly review the features which you have selected so far for installation and then click the Install button to begin the installation of SQL Server 2008 R2.
SQL Server 2008 R2 Ready to Install Screen
22. In the Installation Progress screen you can monitor the progress of SQL Server 2008 R2 installation. Click Next to see the Installation Summary.
SQL Server 2008 R2 Installation Progress Screen 

23. In the Complete Screen the location for the summary log file is mentioned. You can click on the link to review the SQL Server 2008 R2 installation summary.
SQL Server 2008 R2 Installation Complete Screen

List of Cumulative Update Package for SQL 2008 R2:
Once you have successfully completed the installation of SQL Server 2008 R2 read the article titled "New Features in SQL Server 2008 R2" to know more about new features within the product. To know more about the latest SQL Server 2008 R2 Cumulative Updates and Service Packs you can read the following article Microsoft SQL Server 2008 R2 Build Lists / Versions.

One of the most important job responsibilities of a Database Administrator is to make sure that SQL Servers within the organizations are applied with the latest security patches, cumulative updates and services packs which are released by Microsoft. However, it is always challenging to keep track of all the security patches, cumulative updates released by Microsoft. In this article I have compiled an exhaustive list of all the security patches, cumulative updates and service packs for SQL Server 2008 Build Versions released by Microsoft.
For information on Cumulative Updates, Security Patches and Services Packs of other SQL Server Versions, follow the links given below:
It is recommend that you to read the article titled "How to Install a SQL Server 2008 Service Pack" to know more about the Best Practices to follow before installing a SQL Server Service Pack or a Cummulative Update for SQL Server.

Indentifying SQL Server Version

Database Administrators can determine the version of SQL Server they are running by executing the below query.
SELECT
  SERVERPROPERTY('ProductVersion') AS ProductVersion,
 SERVERPROPERTY('ProductLevel') AS ProductLevel,
 SERVERPROPERTY('Edition') AS Edition
GO
ProductVersionProductLevelEdition
10.0.1600.22RTMDeveloper Edition
The Product Version 10.0.1600.22 represents SQL Server 2008 RTM.


SQL Server 2008 Build Versions

Ref:
http://www.mytechmantra.com/LearnSQLServer/SQL_Server_Versions_P1.html
BuildKBDescriptionRelease Date
10.00.5794.0KB2738350 Cumulative Update Package 7 for SQL Server 2008 Service Pack 3 Sept 17, 2012
10.00.5788.0KB2715953 Cumulative Update Package 6 for SQL Server 2008 Service Pack 3 July 16, 2012
10.00.5785.0KB2696626 Cumulative Update Package 5 for SQL Server 2008 Service Pack 3 May 21, 2012
10.0.5775.0KB2673383 Cumulative Update Package 4 for SQL Server 2008 Service Pack 3  Mar 20, 2012
10.0.5770.0KB2648098 Cumulative Update Package 3 for SQL Server 2008 Service Pack 3 Jan 16, 2012
10.0.5768.0KB2633143 Cumulative Update Package 2 for SQL Server 2008 Service Pack 3 Nov 21, 2011
10.0.5766.0KB2617146 Cumulative Update Package 1 for SQL Server 2008 Service Pack 3 Oct 17, 2011
10.0.5500.0KB2546951 SQL Server 2008 Service Pack 3 (SP3) Oct 6, 2011
10.00.4333.0KB2715951 Cumulative Update Package 11 for SQL Server 2008 Service Pack 2 July 16, 2012
10.00.4332.0KB2696625 Cumulative Update Package 10 for SQL Server 2008 Service Pack 2 May 21, 2012
10.0.4330.0KB2673382 Cumulative Update Package 9 for SQL Server 2008 Service Pack 2 Mar 19, 2012
10.0.4326.0KB2648096 Cumulative Update Package 8 for SQL Server 2008 Service Pack 2  Jan 30, 2012
10.0.4323.0KB2617148 Cumulative Update Package 7 for SQL Server 2008 Service Pack 2 Nov 21, 2011
10.0.4321.0KB2582285 Cumulative Update Package 6 for SQL Server 2008 Service Pack 2 Sep 19, 2011
10.0.4316.0KB2555408  Cumulative Update Package 5 for SQL Server 2008 Service Pack 2Jul 18, 2011
10.0.4285.010.0.4285  Cumulative Update Package 4 for SQL Server 2008 Service Pack 2May 16, 2011
10.0.4279.0KB2498535 Cumulative Update Package 3 for SQL Server 2008 Service Pack 2Mar 21, 2011
10.0.4272.0KB2467239 Cumulative Update Package 2 for SQL Server 2008 Service Pack 2Jan 17, 2011
10.0.4266.0KB2289254 Cumulative Update Package 1 for SQL Server 2008 Service Pack 2Nov 15, 2010
10.0.4000.0KB2285068 SQL Server 2008 Service Pack 2 (SP2)Sep 19, 2010
10.0.3798.0 SQL Server 2008 Service Pack 2 - CTPJuly 07, 2010
10.0.2850.0KB2582282 Cumulative Update Package 16 for SQL Server 2008 Service Pack 1 Sep 19, 2011
10.0.2847.0KB2555406 Cumulative Update Package 15 for SQL Server 2008 Service Pack 1  Jul 18, 2011
10.0.2821.0KB2527187 Cumulative Update Package 14 for SQL Server 2008 Service Pack 1May 16, 2011
10.0.2816.0KB2497673 Cumulative Update Package 13 for SQL Server 2008 Service Pack 1Mar 21, 2011
10.0.2808.0KB2467236 Cumulative Update Package 12 for SQL Server 2008 Service Pack 1Jan 17, 2011
10.0.2804.0KB2413738 Cumulative Update Package 11 for SQL Server 2008 Service Pack1Nov 15, 2010
10.0.2799.0KB2279604  Cumulative Update Package 10 for SQL Server 2008 Service Pack 1Sep 21, 2010
10.0.2789.0KB2083921  Cumulative Update Package 9 for SQL Server 2008 Service Pack 1Jul 21, 2010
10.0.2775.0KB981702  Cumulative Update Package 8 for SQL Server 2008 Service Pack 1May 17, 2010
10.0.2766.0KB979065  Cumulative Update Package 7 for SQL Server 2008 Service Pack 1Mar 26, 2010
10.0.2757.0KB977443  Cumulative Update Package 6 for SQL Server 2008 Service Pack 1Jan 18, 2010
10.0.2746.0KB975977  Cumulative Update Package 5 for SQL Server 2008 Service Pack 1Nov 24, 2009
10.0.2734.0KB973602  Cumulative Update Package 4 for SQL Server 2008 Service Pack 1Sep 22, 2009
10.0.2723.0KB971491  Cumulative Update Package 3 for SQL Server 2008 Service Pack 1Jul 21, 2009
10.0.2714.0KB970315  Cumulative Update Package 2 for SQL Server 2008 Service Pack 1May 18, 2009
10.0.2710.0KB969099  Cumulative Update Package 1 for SQL Server 2008 Service Pack 1Apr 16, 2009
10.0.2531.0  SQL Server 2008 Service Pack 1 (SP1)Apr 07, 2009
10.0.2520.0  SQL Server 2008 Service Pack 1 - CTPFeb 23, 2009
10.0.1835.0KB979064  Cumulative Update Package 10 for SQL Server 2008Mar 15, 2010
10.0.1828.0KB977444  Cumulative Update Package 9 for SQL Server 2008Jan 18, 2010
10.0.1823.0KB975976  Cumulative Update Package 8 for SQL Server 2008Nov 16, 2009
10.0.1818.0KB973601  Cumulative Update Package 7 for SQL Server 2008Sep 21, 2009
10.0.1812.0KB971490  Cumulative Update Package 6 for SQL Server 2008Jul 21, 2009
10.0.1806.0KB969531  Cumulative Update Package 5 for SQL Server 2008May 18, 2009
10.0.1798.0KB963036  Cumulative Update Package 4 for SQL Server 2008Mar 17, 2009
10.0.1787.0KB960484  Cumulative Update Package 3 for SQL Server 2008Jan 19, 2009
10.0.1779.0KB958186  Cumulative Update Package 2 for SQL Server 2008Nov 19, 2008
10.0.1763.0KB956717  Cumulative Update Package 1 for SQL Server 2008Oct 28, 2008
10.0.1600.0   SQL Server 2008 RTMAug 06, 2008

Using XP_MSVER System Stored Procedure

You can also execute the xp_msver inbuilt system stored procedure to know more details related to SQL Server which you are currently running within the organization.
Use master
GO
EXEC xp_msver
GO
EXEC XP_MSVER System Stored Procedure Execution Results in SQL Server 2008 R2