Pre-Requisites For Sql Server 2012 / 2014 Installation




  1.  Hardware Requirements for SQL server 2012 / 2014
  2. Operating System compatibility with SQL Server 2012
  3. 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