The main editions of Windows Server are called Essentials, Standard and Datacenter. Their names hint about their user intent and primary customer group. Let's compare the features of these editions more closely now.
If you want to learn more about volume licensing options for businesses, read LicenceDeals Info Corner articles "Volume Licensing: Your Key To Business Optimisation" and "How Can Microsoft Open Licence Program Help Your Business?".
That is the most popular edition of Windows Server. Although suitable for businesses of all sizes, it is mainly for small to medium-sized companies that require minimal virtualisation. The Standard edition includes all the Essentials functionalities and some extra features. It allows you to run two virtual machines, making it a cost-effective option for businesses requiring some virtualisation level.
This operating system by Microsoft provides extensive administrative control over company networks, data storage and applications, and shared services for many users. Editions of Windows Server offer a diverse feature set designed to meet the needs of businesses of all sizes.
What is our recommendation? Evaluate your business needs carefully to get the edition that best suits your requirements. Consider the company size, the virtualisation level of your IT environment, your budget and if you have other technical requirements.
If you are in a micro organisation with a tight budget needing basic server features, go for Essentials. Choose Standard if your company is small to medium-sized and requires additional functionality and some virtualisation. If you work for a large enterprise with extensive virtualised IT infrastructure, the Datacenter edition is the right for you.
Unless noted otherwise, when an OS is supported for a SQL Major version, it remains supported for all subsequent servicing releases. For example, if SQL Server 2016 RTM is supported on Windows 10, this implies that any CUs on top of SQL Server 2016 RTM or SQL Server 2016 Service Pack 1 (SP1) are supported on Windows 10.
Before you install SQL Server on a computer that is running Windows Server 2022 or Windows 11, you must make sure that you fulfill the following minimum requirements, as appropriate for your situation.
Before you install SQL Server on a computer that is running Windows 10 or Windows Server 2016, you must make sure that you fulfill the following minimum requirements, as appropriate for your situation.
The Books Online topic Hardware and Software Requirements for Installing SQL Server 2012 has not yet been updated to reflect the support for Windows Server 2016 and Windows Server 2019.
Before you install SQL Server on a computer that is running Windows Server 2012 R2 or Windows 8.1, you must make sure that you fulfill the following minimum requirements, as appropriate for your situation:
The RTM installation of the product is supported. However, you have to install the respective service packs after the initial setup is complete. Your SQL Server 2008 installation is not supported unless you apply Service Pack 4 after you install the RTM edition. For more information, see How to obtain the latest service pack for SQL Server 2008.
Windows 8 has reach end of support, which means Windows 8 devices no longer receive important security updates. We recommend making the free upgrade to Windows 8.1 to continue receiving security updates and support. For additional information review Update to Windows 8.1 from Windows 8.
Before you install SQL Server on a computer that is running Windows Server 2012 or Windows 8, you must make sure that you fulfill the following minimum requirements, as appropriate for your situation:
The RTM installation of the product is supported. However, you have to install the respective service packs after the initial setup is complete. You will see the following message on the Solution Center page:
The RTM installation of the product is supported. However, you have to install the respective service packs after the initial setup is complete. Your SQL server 2008 installation is not supported unless you apply Service Pack 4 after you install the RTM edition. You will see the following message on the Solution Center page.
You can switch from Server Core or Minimal Server Interface to Full Server when one or more instances of SQL Server 2014 or SQL Server 2012 are installed. However, be aware that you cannot switch from Full Server to Minimal Server Interface or Server Core when one or more instances of SQL Server 2014 or SQL Server 2012 are installed.
To switch from Full Server to Minimal Server Interface or Server Core when one or more instances of SQL Server 2014 or SQL Server 2012 are installed, you must uninstall SQL Server 2014 or SQL Server 2012, switch modes, and then reinstall SQL Server 2014 or SQL Server 2012. However, you can turn on SQL Server 2014 or SQL Server 2012 installation prerequisites in Full Server mode, switch to Server Core mode, and then install SQL Server 2014 or SQL Server 2012.
Minimal Server is a Server Core installation that has Server Manager and other server tools installed. Therefore, the SQL Server Setup program performs the same installation steps in Windows Server 2012 R2 Minimal Server Interface mode and Windows Server 2012 Minimal Server Interface mode and Server Core mode. Additionally, you can switch between Server Core and Minimal Server when one or more instances of SQL Server 2014 or SQL Server 2012 are installed. This is a supported scenario.
SQL Server Reporting Services 2012 is not supported on Windows Server 2012 R2 Server Core, Windows Server 2012 Server Core, Windows Server 2012 R2 Minimal Server Interface mode, or Windows 2012 Minimal Server Interface mode. You can install SQL Server Reporting Services 2012 on a server that is running Windows Server 2012 in Full Server mode and then switch to Windows Server 2012 Server Core mode. However, this configuration is not supported.
We recommend that you uninstall all the SQL Server 2012 features that are not supported on a server that is running Windows Server 2012 R2 or Windows Server 2012 in Server Core mode. For information about how to do this, see Install SQL Server 2012 on Server Core).
This section provides support information about instances of SQL Server 2005 in Windows 8.1 or Windows 8 environments. It also describes the options that are available for customers who are using SQL Server 2005.Microsoft SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows 10, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8. You will receive a warning in the Action Center if Windows 10, Windows 8.1, or Windows 8 detects an instance of SQL Server 2005.
For more information about how to uninstall an existing instance of SQL Server 2005, see How to manually uninstall an instance of SQL Server 2005 or How to: Uninstall an Existing Instance of SQL Server 2005 (Setup).
If you type winmsd at a command prompt the response should tell you if you have enterprise or not. The enterprise edition of NT 4.0 is equivilant to Windows 2000 Advanced Server. This is why they want to know what version you are running.
Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add newsl...@nl.technologyadvice.com to your contacts list.
I am getting a Proliant ML350p Gen 8 server for home use. It's a machine for learning server management/deployment and just having fun playing with high end gear. I will also use it for oddball things like running BOINC, gaming, and file/backup storage.
I would like to know which version of Windows Server I should purchase for the easiest installation and most compatibility. Can I go with the latest and greatest, Windows Server 2019? Would I be better served (no pun intended) with something like Server 2016?
The server has two E5-2640 V2 processors which gives me 12 physical cores. I'm sure one day I will want to max out the system and upgrade to something like the E5-2697 V2 which has has 12 physical cores per processor. Installing two of them will give me 24 cores. Wow-wee!
How would licensing and support work for that many cores? Don't the Server ediitions give you 16 core support standard and then an 8-core adder must be purchased? I'm wondering now if I would be better off going with a Pro or Enterprise edition of Windows 10 because they don't track processor and core counts.
Has Server 2019 been shown not to work or has it just not been officially tested by HP? I imagine it would work by itself but would there be driver incompatibilities? As a hobbyist and second hand owner, I'm ok with "unofficial" and "uncertified" knowledge Server 2019 would work.
Thanks for your reply and for testing Server 2019! You showed what I was afraid would happen ... driver incompatibility issues. Since Server 2019 didn't work I would imagine Windows 10 Pro, Workstation, and Enterprise won't install either because of the drivers too.
I understand Server 2016 is the tested and certified choice of Windows operating system but I still had an itch to try 2019. Microsoft offers evaluation copies of Server 2016 and 2019 and they are free to download. The evaluation period is 180 days. I decided to download both and see like an experiement when and were the BSOD will appear. What do I have to lose? Maybe it will help the forum.
I had no problems installing Server 2019 on my Gen8. No blue screen of death. No lock ups. No system errors. I am a little surprised .. no, I'm really surprised! Next I need to find a long, long, long Ethernet cable to connect my Gen8 to my home router and install updates from Microsoft. Maybe that is where I will see some problems. So far, so good though.
7fc3f7cf58