Microsoft SQL Server 2008 R2 Enterprise Edition X86 And X64 16
These settings are required for both server and client computers. The DisabledByDefault and Enabled settings are required to be created on Windows 7 clients and Windows Server 2008 R2 servers. On Windows 8 and later versions of the client operating systems or Windows Server 2012 server and later versions of the server operating systems, TLS 1.2 should already be enabled. If you are implementing a deployment policy for Windows Registry which needs to be independent of the OS release, then we recommend adding the mentioned registry keys to the policy.
Microsoft SQL Server 2008 R2 Enterprise Edition X86 and X64 16
SQL Server 2008 R2 is Microsoft's premier enterprise data platform. In addition to its highly scalable relational database engine, SQL Server 2008 R2 also provides industry-leading business intelligence (BI) capabilities with its SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS) subsystems. If you're using one of the earlier editions of SQL Server or are considering moving from a competing database such as Oracle or DB2, then this article will help you choose the edition of SQL Server 2008 R2 that's right for your organization. You'll learn about the features in the different editions of SQL Server 2008 R2, as well as the hardware and software requirements for each edition.
The different editions of SQL Server share several common software requirements. First, the SQL Server setup program requires Microsoft Windows Installer 4.5 or later. All the x86 and x64 editions of SQL Server, except the SQL Server Express versions, require .NET Framework 3.5 SP1. SQL Server 2008 R2 Express requires .NET Framework 2.0. The IA-64 version also requires .NET Framework 2.0. In addition, Microsoft Internet Explorer (IE) 6 SP1 or later is required. For client connectivity, SQL Server 2008 R2 also requires the Shared Memory, Named Pipes, or TCP/IP network protocols.
There are several different editions of SQL Server. Each edition is designed to meet a different level of requirements, and each edition has its own set of features and support for different operating systems. The following sections highlight the main features in each edition of SQL Server 2008 R2, including the operating systems that are supported by each edition.
SQL Server 2008 R2 Datacenter provides the complete feature set available in SQL Server 2008. The Datacenter edition provides the maximum scalability of the different SQL Server 2008 R2 editions and is designed for the largest enterprise implementations that require maximum scalability. The Datacenter edition is priced at $54,990 per processor or $13,748 if you have Software Assurance (SA). The features available in SQL Server 2008 R2 Datacenter include:
SQL Server 2008 R2 Enterprise is designed for large, highly scalable enterprise implementations. IT provides support from almost all of SQL Server 2008 R2's features except for StreamInsight Premium. Notably, it provides support for all of the high-availability features. The Enterprise edition is priced at $27,495 per processor ($6,874 with SA) or $8,592 per server ($2,148 with SA), including 25 CALs. The features that are available in SQL Server 2008 R2 Enterprise are:
SQL Server 2008 R2 Standard provides the core SQL Server 2008 feature set but doesn't provide the enterprise-oriented features found in SQL Server 2008 R2 Enterprise. SQL Server Standard is priced at $7,171 per processor ($1,793 with SA) or $898 ($224 with SA) per server with five CALs. SQL Server 2008 R2 Standard includes a number of features that aren't available in the Workgroup, Web, or Express editions of SQL Server 2008 R2. SQL Server 2008 R2 Standard features include:
SQL Server 2008 R2 Web Edition is designed to meet the database needs of web hosting providers. SQL Server 2008 R2 Web Edition is designed to provide a highly scalable relational database platform for web hosting providers. It includes support for SSRS but not for the other BI subsystems. It's also licensed differently than the other editions of SQL Server. SQL Server 2008 R2 Web Edition is priced at $3,500 per processor ($876 with SA) and $15 per month. Some of the notable features in SQL Server 2008 R2 Web Edition include:
SQL Server 2008 R2 Workgroup is designed to provide a relational database for departments and branch offices. SQL Server 2008 R2 Workgroup is priced at $3,743 ($936 with SA) or $730 ($182 with SA) per server, including five CALs. The main features of SQL Server 2008 R2 Workgroup are:
SQL Server 2008 R2 Express is the low-end of the SQL Server family. SQL Server 2008 R2 Express shares the same code base as the other editions of SQL Server 2008 and is able to support small-scale multiuser databases. SQL Server 2008 R2 Express is a free download and is often used as the built-in database for other Microsoft applications, such as SharePoint and the System Center family of products. Some of the important characteristics of SQL Server 2008 R2 Express include:
The SQL Server 2008 R2 Developer edition includes all the features and requirements of SQL Server 2008 R2 Datacenter. However, the SQL Server 2008 R2 Developer edition is licensed for use as a development and test system, not as a production server. It's licensed at $49.95 per developer.
SQL Server 2008 R2 Express with Tools is essentially the same as the SQL Server 2008 R2 Express edition. It has the same requirements and operating system support. The only real difference is that is also provides SQL Server Management Studio Express, to let you manage the SQL Server Express instance and databases.
SQL Server includes better compression features, which also helps in improving scalability.[22] It enhanced the indexing algorithms and introduced the notion of filtered indexes. It also includes Resource Governor that allows reserving resources for certain users or workflows. It also includes capabilities for transparent encryption of data (TDE) as well as compression of backups.[17] SQL Server 2008 supports the ADO.NET Entity Framework and the reporting tools, replication, and data definition will be built around the Entity Data Model.[23] SQL Server Reporting Services will gain charting capabilities from the integration of the data visualization products from Dundas Data Visualization, Inc., which was acquired by Microsoft.[24] On the management side, SQL Server 2008 includes the Declarative Management Framework which allows configuring policies and constraints, on the entire database or certain tables, declaratively.[16] The version of SQL Server Management Studio included with SQL Server 2008 supports IntelliSense for SQL queries against a SQL Server 2008 Database Engine.[25] SQL Server 2008 also makes the databases available via Windows PowerShell providers and management functionality available as Cmdlets, so that the server and all the running instances can be managed from Windows PowerShell.[26]
SQL Server 2008 had mainstream support until July 8, 2014, and extended support until July 9, 2019.[28] Volume licensed Standard, Web, Enterprise, Workgroup and Datacenter editions of SQL Server 2008 are eligible for the Extended Security Updates program.[29] The first term of yearly installment ended on July 14, 2020, the second term ended on July 13, 2021, and the third term ended on July 12, 2022.[30][31] Those volume licensed editions rehosted on Microsoft Azure automatically receive ESUs until July 11, 2023.[32][33][34][35]
SQL Server 2008 R2 had mainstream support until July 8, 2014, and extended support until July 9, 2019.[44] Volume licensed Standard, Enterprise, Datacenter and Embedded editions of SQL Server 2008 R2 are eligible for the Extended Security Updates program.[29] The first term of yearly installment ended on July 14, 2020, the second term ended on July 13, 2021, and the third term ended on July 12, 2022.[30][31] Those volume licensed editions rehosted on Microsoft Azure automatically receive ESUs until July 11, 2023.[32]
Microsoft Windows Server 2008 (Arcserve Replication r12.5,r12 SP1, r15, r15.1, r15.2, or r16)
Microsoft Windows Server 2008 R2 (Arcserve Replicationr12.5 SP2, r15, r15.1, r15.2, or r16)
Replica servers
Windows Server 2008 R2 Standard, Enterprise, Datacenter andWeb Server editions
Windows Server 2008 R2 with Service Pack 1 Standard,Enterprise, Datacenter and Web Server editions
Windows Server 2008:Windows Server 2008 x64 Standard, Enterprise, Datacenter,Web Server, HPC editions
Windows Server 2008 x64 without Hyper-V Standard,Enterprise, Datacenter editions
Windows Server 2008 x86 Standard, Enterprise, Datacenter,Web Server, HPC editions
Windows Server 2008 x86 without Hyper-V Standard,Enterprise, Datacenter editions
Windows Server 2008 x64 Service Pack 2 Standard,Enterprise, Datacenter, Web Server, HPC editions
Windows Server 2008 x64 Service Pack 2 without Hyper-VStandard, Enterprise, Datacenter editions
Windows Server 2008 x86 Service Pack 2 Standard,Enterprise, Datacenter, Web Server, HPC editions
Windows Server 2003:Windows Server 2003 x86 with Service Pack 2 Standard,Enterprise, Datacenter, Web Server editions
Windows Server 2003 x64 with Service Pack 2 Standard,Enterprise, Datacenter editions
Windows Server 2003 R2:Windows Server 2003 R2 x86 with Service Pack 2 Standard,Enterprise, Datacenter, Web Server editions
Windows Server 2003 R2 x64 with Service Pack 2 Standard,Enterprise, Datacenter editions
Windows 7:Windows 7 x86 Professional, Enterprise, Ultimate editions
Windows 7 x64 Professional, Enterprise, Ultimate editions
Windows 7 x86 with Service Pack 1 Professional, Enterprise,Ultimate editions
Windows 7 x64 with Service Pack 1 Professional, Enterprise,Ultimate editions
Windows Vista:Windows Vista x86 with Service Pack 1 Business, Enterprise,Ultimate editions
Windows Vista x64 with Service Pack 1 Business, Enterprise,Ultimate editions
Windows Vista x86 with Service Pack 2 Business, Enterprise,Ultimate editions
Windows Vista x64 with Service Pack 2 Business, Enterprise,Ultimate editions
Windows XP Professional:Windows XP Professional x86 Edition with Service Pack 3(for VMs configured with 1 or 2 virtual processors)
Windows XP Professional x86 Edition with Service Pack 2(for VMs configured with 1 virtual processor)
Windows XP Professional x64 with Service Pack 2 (for VMsconfigured with 1 or 2 virtual processors)
Windows Server 2008 Hyper-V:Windows Server 2008 Standard x64 SP1, SP2
Windows Server 2008 Enterprise x64 SP1, SP2
Windows Server 2008 Data Center x64 SP1, SP2
Windows Server 2008 R2 Hyper-V:Windows Server 2008 R2 Standard, Enterprise, Datacenter andWeb Server editions
Windows Server 2008 R2 SP1 Standard, Enterprise, Datacenterand Web Server editions
Windows Small Business Server (SBS) 2003
Windows Small Business Server (SBS) 2008
Windows Small Business Server (SBS) 2011
VMware -- VMware Virtual Disk Development Kit (VDDK) andVCB Framework are independent software products provided byVMware. The Agent for Virtual Machines requires VDDK, VCBFramework, or both, to back up VMs hosted on ESX Serversystems running the following applications: