MS SQL Server 2012 - DBA Articles

Hardware and Software Requirements for Installing SQL Server 2012



The following sections list the minimum hardware and software requirements to install and run SQL Server 2012. For both 32-bit and 64-bit editions of SQL Server 2012, the following considerations apply:

01. We recommend that you run SQL Server 2012 on computers with the NTFS file format. Installing SQL Server 2012 on a computer with FAT32 file system is supported but not recommended as it is less secure than the NTFS file system.

02. SQL Server Setup will block installations on read-only, mapped, or compressed drives.

03. To make sure that the Visual Studio component can be installed correctly, SQL Server requires you to install an update. SQL Server Setup checks for the presence of this update and then requires you to download and install the update before you can continue with the SQL Server installation.

04. The installation of SQL Server 2012 fails if you launch the setup through Terminal Services Client. Launching SQL Server Setup through Terminal Services Client is not supported.

05. SQL Server Setup installs the following software components required by the product:

     a. SQL Server Native Client

     b. SQL Server Setup support files

Software Requirements

Component Requirement
.NET Framework .NET 3.5 SP1 is a requirement for SQL Server 2012 when you select Database Engine, Reporting Services, Master Data Services, Data Quality Services, Replication, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.

.NET 4.0 is a requirement for SQL Server 2012. SQL Server installs .NET 4.0 during the feature installation step.
Windows PowerShell SQL Server 2012 does not install or enable Windows PowerShell 2.0; however Windows PowerShell 2.0 is an installation prerequisite for Database Engine components and SQL Server Management Studio.
Network Software Supported operating systems for SQL Server 2012 have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA.
Virtualization SQL Server 2012 is supported in virtual machine environments running on the Hyper-V role in: Windows Server 2008 SP2 Standard, Enterprise and Datacenter editions.

Windows Server 2008 R2 SP1 Standard, Enterprise, and Datacenter editions.

Windows Server 2012 Datacenter and Standard editions.

In addition to resources required by the parent partition, each virtual machine (child partition) must be provided with sufficient processor resources, memory, and disk resources for its SQL Server 2012 instance.
Internet Software Internet Explorer 7 or a later version is required for Microsoft Management Console (MMC), SQL Server Data Tools (SSDT), the Report Designer component of Reporting Services, and HTML Help.


Hardware Requirements

Component Requirement
Hard Disk SQL Server 2012 requires a minimum of 6 GB of available hard-disk space.

Disk space requirements will vary with the SQL Server 2012 components you install.
Drive A DVD drive, as appropriate, is required for installation from disc.
Monitor SQL Server 2012 requires Super-VGA (800x600) or higher resolution monitor.
Internet Internet functionality requires Internet access (fees may apply).
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


More Reference URL: http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.110%29.aspx

* * * * *


Email Your Comment To AUTHOR