- Hardware Requirements for SQL server 2012 / 2014
- Operating System compatibility with SQL Server 2012
- Operating System compatibility with SQL Server 2014
I have included below details to be available handy instead searching every time on MSDN, Other wise these are easily available in MSDN.
Hardware Requirements:
| Memory | Minimum: Express Editions: 512 MB All other editions: 1 GB |
| Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance. |
|
| Processor Speed | Minimum: x86 Processor: 1.0 GHz x64 Processor: 1.4 GHz Recommended: 2.0 GHz or faster |
| Processor Type | x64 Processor: AMD Opteron, AMD Athlon 64, Intel
Xeon with Intel EM64T support, Intel Pentium IV with EM64T support x86 Processor: Pentium III-compatible processor or faster |
OS compatibility with SQL Server 2012
SQL Server 2012 edition
|
Operating system
|
SQL
Server 2012 x64 Enterprise,
|
Windows
Server 2008 R2 SP1 Datacenter, Enterprise, Standard, and Web or above
|
SQL
Server 2012 x86 Enterprise,
|
Windows
Server 2008 R2 SP1 Datacenter, Enterprise, Standard, and Web or above
|
SQL
Server 2012 x64 Standard
|
Windows
Server 2008 R2 SP1 Datacenter, Enterprise, Standard,Foundation, and Web or
above
|
Windows
Server 2008 SP2 Datacenter, Enterprise, Standard, and Web or above
|
|
Windows
7 SP1 x64 Ultimate, Enterprise, and Professional
|
|
Windows
Vista SP2 x64 Ultimate, Enterprise, and Business
|
|
SQL
Server 2012 x86 Standard
|
Windows
Server 2008 R2 SP1 Datacenter, Enterprise, Standard,Foundation, and Web or
above
|
Windows
Server 2008 (x64 and x86) SP2 Datacenter, Enterprise,Standard, and Web or
above
|
|
Windows
7 SP1 (x64 and x86) Ultimate, Enterprise, and Professional
|
|
Windows
Vista SP2 (x64 and x86) Ultimate, Enterprise, and Business
|
|
SQL
Server 2012 x64 Developer,
|
Windows
Server 2008 R2 SP1 Datacenter, Enterprise, Standard,Foundation, and Web or
above
|
Express,
Express with Tools, and
|
Windows
Server 2008 (x64) SP2 Datacenter, Enterprise, Standard,and Web or above
|
Express with Advanced Services
|
Windows
7 SP1 (x64) Ultimate, Enterprise, Professional, Home Premium, and Home Basic
|
Windows
Vista SP2 (x64)
|
|
SQL
Server 2012 x86 Developer,
|
Windows
Server 2008 R2 SP1 Datacenter, Enterprise, Standard,Foundation, and Web or
above
|
Express,
Express with Tools, and
|
Windows
Server 2008 (x64 and x86) SP2 Datacenter, Enterprise,Standard, and Web or
above
|
Express with Advanced Services
|
Windows
7 SP1 (x64 and x86) Ultimate, Enterprise, Professional, Home Premium, and
Home Basic
|
Windows
Vista SP2 (x64 and x86) Ultimate, Enterprise, Business, Home Premium, and
Home Basic
|
OS Compatibility With SQL Server 2014
| SQL Server 2014 Editions | 32-bit | 64-bit |
| SQL Server Enterprise | Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 32-bit Windows Server 2008 SP2 Standard 32-bit Windows Server 2008 SP2 Web 32-bit |
Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Web 64-bit |
| SQL Server Business Intelligence | Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 32-bit Windows Server 2008 SP2 Standard 32-bit Windows Server 2008 SP2 Web 32-bit |
Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Web 64-bit |
| SQL Server Standard | Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Foundation 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows 8.1 32-bit Windows 8.1 Pro 32-bit Windows 8.1 Enterprise 32-bit Windows 8.1 64-bit Windows 8.1 Pro 64-bit Windows 8.1 Enterprise 64-bit Windows 8 32-bit Windows 8 Pro 32-bit Windows 8 Enterprise 32-bit Windows 8 64-bit Windows 8 Pro 64-bit Windows 8 Enterprise 64-bit Windows 7 SP1 Ultimate 64-bit Windows 7 SP1 Enterprise 64-bit Windows 7 SP1 Professional 64-bit Windows 7 SP1 Ultimate 32-bit Windows 7 SP1 Enterprise 32-bit Windows 7 SP1 Professional 32-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Foundation 64-bit Windows Server 2008 SP2 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 32-bit Windows Server 2008 SP2 Standard 32-bit Windows Server 2008 SP2 Web 32-bit |
Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Foundation 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows 8.1 64-bit Windows 8.1 Pro 64-bit Windows 8.1 Enterprise 64-bit Windows 8 64-bit Windows 8 Pro 64-bit Windows 8 Enterprise 64-bit Windows 7 SP1 Ultimate 64-bit Windows 7 SP1 Enterprise 64-bit Windows 7 SP1 Professional 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Foundation 64-bit |
SQL
Server Web
|
Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 32-bit Windows Server 2008 SP2 Standard 32-bit Windows Server 2008 SP2 Web 32-bit |
Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Web 64-bit |
| SQL Server Developer | Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows 8.1 32-bit Windows 8.1 Pro 32-bit Windows 8.1 Enterprise 32-bit Windows 8.1 64-bit Windows 8.1 Pro 64-bit Windows 8.1 Enterprise 64-bit Windows 8 32-bit Windows 8 Pro 32-bit Windows 8 Enterprise 32-bit Windows 8 64-bit Windows 8 Pro 64-bit Windows 8 Enterprise 64-bit Windows 7 SP1 Ultimate 64-bit Windows 7 SP1 Enterprise 64-bit Windows 7 SP1 Professional 64-bit Windows 7 SP1 Home Premium 64-bit Windows 7 SP1 Home Basic 64-bit Windows 7 SP1 Ultimate 32-bit Windows 7 SP1 Enterprise 32-bit Windows 7 SP1 Professional 32-bit Windows 7 SP1 Home Premium 32-bit Windows 7 SP1 Home Basic 32-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 32-bit Windows Server 2008 SP2 Standard 32-bit Windows Server 2008 SP2 Web 32-bit |
Windows
Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows 8.1 64-bit Windows 8.1 Pro 64-bit Windows 8.1 Enterprise 64-bit Windows 8 64-bit Windows 8 Pro 64-bit Windows 8 Enterprise 64-bit Windows 7 SP1 Ultimate 64-bit Windows 7 SP1 Enterprise 64-bit Windows 7 SP1 Professional 64-bit Windows 7 SP1 Home Premium 64-bit Windows 7 SP1 Home Basic 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Web 64-bit |
| SQL Server Express | Windows Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Foundation 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows 8.1 32-bit Windows 8.1 Pro 32-bit Windows 8.1 Enterprise 32-bit Windows 8.1 64-bit Windows 8.1 Pro 64-bit Windows 8.1 Enterprise 64-bit Windows 8 32-bit Windows 8 Pro 32-bit Windows 8 Enterprise 32-bit Windows 8 64-bit Windows 8 Pro 64-bit Windows 8 Enterprise 64-bit Windows 7 SP1 Ultimate 64-bit Windows 7 SP1 Enterprise 64-bit Windows 7 SP1 Professional 64-bit Windows 7 SP1 Home Premium 64-bit Windows 7 SP1 Home Basic 64-bit Windows 7 SP1 Ultimate 32-bit Windows 7 SP1 Enterprise 32-bit Windows 7 SP1 Professional 32-bit Windows 7 SP1 Home Premium 32-bit Windows 7 SP1 Home Basic 32-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Foundation 64-bit Windows Server 2008 SP2 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 32-bit Windows Server 2008 SP2 Standard 32-bit Windows Server 2008 SP2 Web 32-bit |
Windows Server 2012 R2 Datacenter 64-bit Windows Server 2012 R2 Standard 64-bit Windows Server 2012 R2 Essentials 64-bit Windows Server 2012 R2 Foundation 64-bit Windows Server 2012 Datacenter 64-bit Windows Server 2012 Standard 64-bit Windows Server 2012 Essentials 64-bit Windows Server 2012 Foundation 64-bit Windows Server 2008 R2 SP1 Datacenter 64-bit Windows Server 2008 R2 SP1 Enterprise 64-bit Windows Server 2008 R2 SP1 Standard 64-bit Windows Server 2008 R2 SP1 Foundation 64-bit Windows Server 2008 R2 SP1 Web 64-bit Windows 8.1 32-bit Windows 8.1 Pro 32-bit Windows 8.1 Enterprise 32-bit Windows 8.1 64-bit Windows 8.1 Pro 64-bit Windows 8.1 Enterprise 64-bit Windows 8 32-bit Windows 8 Pro 32-bit Windows 8 Enterprise 32-bit Windows 8 64-bit Windows 8 Pro 64-bit Windows 8 Enterprise 64-bit Windows 7 SP1 Ultimate 64-bit Windows 7 SP1 Enterprise 64-bit Windows 7 SP1 Professional 64-bit Windows 7 SP1 Home Premium 64-bit Windows 7 SP1 Home Basic 64-bit Windows 7 SP1 Ultimate 32-bit Windows 7 SP1 Enterprise 32-bit Windows 7 SP1 Professional 32-bit Windows 7 SP1 Home Premium 32-bit Windows 7 SP1 Home Basic 32-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 64-bit Windows Server 2008 SP2 Standard 64-bit Windows Server 2008 SP2 Foundation 64-bit Windows Server 2008 SP2 Web 64-bit Windows Server 2008 SP2 Datacenter 64-bit Windows Server 2008 SP2 Enterprise 32-bit Windows Server 2008 SP2 Standard 32-bit Windows Server 2008 SP2 Web 32-bit |
No comments:
Post a Comment