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

* * * * *

Your Comment To AUTHOR