Categories

Affiliate Questions
35
Billing & Accounts
48
Client Area Tutorials
37
Cloud Hosting
27
Control Panels
758
Database Server
116
Dedicated Servers
8
Form Downloads
5
Mail Servers Tutorials
222
Miscellaneous Articles
234
Pre-Sales Questions
611
Video Tutorials
1
VPS Hosting
663
Web Hosting
176
Web Services
111
Website Migration
9
WordPress Hosting
196

  Categories

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket

Microsoft SQL Server 2016 Recommendation

Print
The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the earlier MS SQL Server releases, SQL Server 2016 Express edition is also FREE and capable to support small to medium size applications. Following are the minimum hardware and software requirements to install and run SQL Server 2016.

 

Component
Requirements
Supported OS for SQL Server Express Edition
Windows Server 2012 R2 Datacenter, Windows Server 2012 R2 Standard, Windows Server 2012 R2 Essentials, Windows Server 2012 R2 Foundation, Windows Server 2012 Datacenter, Windows Server 2012 Standard, Windows Server 2012 Essentials, Windows Server 2012 Foundation, Windows 10 Home, Windows 10 Professional, Windows 10 Enterprise, Windows 8.1, Windows 8.1 Pro, Windows 8.1 Enterprise, Windows 8, Windows 8 Pro, Windows 8 Enterprise.
Supported OS for SQL Server Web Edition
Windows Server 2012 R2 Datacenter, Windows Server 2012 R2 Standard, Windows Server 2012 R2 Essentials, Windows Server 2012 R2 Foundation, Windows Server 2012 Datacenter, Windows Server 2012 Standard, Windows Server 2012 Essentials, Windows Server 2012 Foundation.
Supported OS for SQL Server Standard Edition Windows Server 2012 R2 Datacenter, Windows Server 2012 R2 Standard, Windows Server 2012 R2 Essentials, Windows Server 2012 R2 Foundation, Windows Server 2012 Datacenter, Windows Server 2012 Standard, Windows Server 2012 Essentials, Windows Server 2012 Foundation, Windows 10 Home, Windows 10 Professional, Windows 10 Enterprise, Windows 8.1, Windows 8.1 Pro, Windows 8.1 Enterprise, Windows 8, Windows 8 Pro, Windows 8 Enterprise.
Memory
Minimum
  • Express Edition: 512 MB
  • All other Editions: 1 GB
Recommended
  • Express Edition: 1 GB
  • All other Editions: At least 4 GB to ensure optimal performance.
Processor Type
 X64 Processor
  • AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support. SQL Server 2016 does not support x86 processors.
Processor Speed
Minimum
  • x64 Processor: 1.4 GHz
Recommended
  • 2.0 GHz or faster
Hard Disk Space
  • SQL Server 2016 requires a minimum of 6 GB of available hard-disk space.
  • Disk space requirements may vary with the SQL Server 2016 components you install. Refer this for more information on disk space requirements of SQL Server 2016.
Hardware & Software Requirements

  • SQL Server 2016 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 setup automatically installs .NET Framework. You can also manually install .NET Framework 4.6 manually.

  • Windows 8.1, and Windows Server 2012 R2 require update KB2919355 before installing .NET Framework 4.6.
File Formats

  • It is recommended to run SQL Server 2016 on computers with the NTFS or ReFS file formats. SQL Server 2016 can be installed on computer with FAT32 file system, but not recommended as it is less secure than the NTFS or ReFS file systems.
Setup on Remote Desktop

  • SQL Server 2016 setup will fail, when the setup is launched through Remote Desktop Connection with the media on a local resource in the RDC client. To install SQL Server 2016 on the remote server, the media must be on a network share or local to the physical or virtual machine. SQL Server installation media may be either on a network share, a mapped drive, a local drive, or presented as an ISO to a virtual machine.

Above are minimum requirements to run MS SQL Server 2016 with the basic components. Windows Operating System along with other software like IIS, WebsitePanel, DNS Server, FTP Server, MySQL and Mail Server will create additional overhead to Windows VPS. To prevent your VPS running out of memory, we recommend following VPS configurations.


Windows Server 2012 R2 with MS SQL Server 2016

  • vCPU: 3 vCPU
  • RAM: 3 GB or Higher
  • Disk space: Minimum 45 GB


Recommended VPS Plans



Get Windows VPS

Was this answer helpful?

Related Articles

Operation must use an updateable query Microsoft OLE DB Provider for ODBC Drivers error '80004005' .[Microsoft] [ODBC Microsoft Access Driver] This error usually occurs when you try to insert or update data in MS Access database i.e. you do... Choosing Between SQL Server 2012 and SQL Server 2014 If you are running SQL Server 2008 R2, you might be looking to upgrade your SQL server to... Where is the database folder for MS-Access database? 'db' folder created along with the 'www' or 'wwwroot' folder is the recommended folder for .mdb... How to Shrink Transaction Logs of Database in MS SQL? This article will assist you to shrink/truncate the transaction logs of the database in MS SQL... Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1 This error occurs because the field name that you used in the query syntax does not exist. Often...
« Back

Copyright © 2003-2025 AccuWebHosting.com USA | Designed By: AccuWebTech.Com

chat