SQL Server in Windows operating system – SQL Server

SQL Server in Windows operating system – SQL Server
  • Article
  • 17 minutes to check out

This post consists of assistance about how to utilize various variations of Microsoft SQL Server on a computer system that is running Windows running system.

Original item variation: SQL Server
Original KB number: 2681562

Summary

Note

Unless kept in mind otherwise, when an OS is supported for a SQL Major variation, it stays supported for all subsequent maintenance releases. If SQL Server 2016 RTM is supported on Windows 10, this suggests that any CUs on top of SQL Server 2016 RTM or SQL Server 2016 Service Pack 1 (SP1) are supported on Windows 10.

How to utilize this short article:

  1. Find out the minimum requirements for the SQL Server variation you are attempting to set up for the matching OS.
    Windows Version/SQL Version SQL Server 2019 SQL Server 2017 SQL Server 2016 SQL Server 2014 SQL Server 2012 SQL Server 2008 R2 SQL Server 2008 More Information/Limitations
    Windows Server 2022 Yes (RTM) Yes (RTM) Not supported Not supported Not supported Not supported Not supported Additional details for Windows Server 2022 environments
    Windows 11 Yes (RTM) Yes (RTM) Not supported Not supported Not supported Not supported Not supported Additional details for Windows 11 environments
    Windows 10 Yes (RTM) Yes (RTM) Yes (SP2) Yes (SP3) Yes (SP4) Not supported Not supported Additional details for Windows 10 environments
    Windows Server 2019 Yes (RTM) Yes (RTM) Yes (SP2) Yes (SP3) Yes (SP4) Not supported Not supported Additional details for Windows Server 2019 environments
    Windows Server 2016 Yes (RTM) Yes (RTM) Yes (SP2) Yes (SP3) Yes (SP4) Not supported Not supported Additional details for Windows Server 2016 environments
    Windows 8.1 No Yes (RTM) Yes (SP2) Yes (SP3) Yes (SP4) Yes (SP3) Yes (SP4) Additional info for Windows 8.1 environments
    Windows Server 2012 R2 No Yes (RTM) Yes (SP2) Yes (SP3) Yes (SP4) Yes (SP3) Yes (SP4) Additional details for Windows Server 2012 R2 environments
    Windows 8 No Yes (RTM) Yes (SP2) Yes (SP3) Yes (SP4) Yes (SP3) Yes (SP4) Additional info for Windows 8 environments
    Windows Server 2012 No Yes (RTM) Yes (SP2) Yes (SP3) Yes (SP4) Yes (SP3) Yes (SP4) Additional details for Windows Server 2012 environments
    Hardware and Software Requirements page SQL Server 2019 SQL Server 2017 SQL Server 2016 SQL Server 2014 SQL Server 2012 SQL Server 2008 R2 SQL Server 2008
  2. To discover responses to the following concerns, examine the matching link under Hardware and Software Requirements page.
    • Which editions of SQL Server work with which variations of Windows?
    • What are the.NET Framework requirements for my SQL variation?
  3. Use the More Information/Limitations column in the above table to discover extra info about running SQL server on the particular os.

    For example, if you wish to set up SQL Server 2016 Developer Edition on Windows 10 Professional:

    1. Check if SQL Server 2016 is supported on Windows10 The matching worth in the above table is Yes (SP2)
      • Yes suggests that SQL Server 2016 on Windows 10 is supported.
      • ( SP2) suggests that SQL Server 2016 must be upgraded to a minimum of SP2 for it to be supported on Windows 10.
    2. The Hardware and Software Requirements page for SQL 2016 validates that SQL Server 2016 Developer edition is supported on Windows 10 Professional.
    3. The More Information/Limitations column for Windows Server 2016 do not call out any extra recognized problems for this setup.

Minimum SQL Server variation requirements for Windows Server 2022 and Windows 11

This area explains the minimum variation requirements to set up SQL Server on a computer system that is running Windows Server 2022 or Windows 11.

Before you set up SQL Server on a computer system that is running Windows Server 2022 or Windows 11, you should make certain that you meet the following minimum requirements, as suitable for your circumstance.

  • For SQL Server 2019 on Windows

    The release is supported at the SQL Server 2019 on Windows RTM Release variation.

  • For SQL Server 2017 on Windows

    The release is supported at the SQL Server 2017 on Windows RTM Release variation.

  • For SQL Server 2016 and older variations

    SQL Server 2016 and older variations are not supported on Windows Server 2022 or Windows 11.

Minimum SQL Server variation requirements for Windows Server 2019

This area explains the minimum variation requirements to set up SQL Server on a computer system that is running Windows Server 2019.

Before you set up SQL Server on a computer system that is running Windows Server 2019 you need to ensure that you satisfy the following minimum requirements, as proper for your scenario.

  • For SQL Server 2019 on Windows

    The release is supported at the SQL Server 2019 on Windows RTM Release variation.

  • For SQL Server 2017 on Windows

    The release is supported at the SQL Server 2017 on Windows RTM Release variation.

  • For SQL Server 2016

    You need to use SQL Server 2016 Service Pack 2 or a later upgrade. To find out more, see How to get the current service pack for SQL Server 2016

  • For SQL Server 2014

    You need to use SQL Server 2014 Service Pack 3 or a later upgrade. For additional information, see How to acquire the most recent service pack for SQL Server 2014

  • For SQL Server 2012

    You need to use SQL Server 2012 Service Pack 4 or a later upgrade. For more details, see How to acquire the most recent service pack for SQL Server 2012

    Note
    • Make sure that you examine recognized setup problems when you set up SQL Server 2012 on Windows 10 or Windows Server 2016.
    • The Books Online subject Hardware and Software Requirements for Installing SQL Server 2012 has actually not yet been upgraded to show the assistance for Windows Server 2016 and Windows Server 2019.
  • For SQL Server 2008 R2

    SQL Server 2008 R2 is not supported on Windows 10 or Windows Server 2016.

  • For SQL Server 2008

    SQL Server 2008 is not supported on Windows 10 or Windows Server 2016.

Minimum SQL Server variation requirements for Windows 10 and Windows Server 2016

This area explains the minimum variation requirements to set up SQL Server on a computer system that is running Windows 10 or Windows Server 2016.

Before you set up SQL Server on a computer system that is running Windows 10 or Windows Server 2016, you need to ensure that you meet the following minimum requirements, as suitable for your scenario.

  • For SQL Server 2019 on Windows

    The release is supported at the SQL Server 2019 on Windows RTM Release variation.

  • For SQL Server 2017 on Windows

    The release is supported at the SQL Server 2017 on Windows RTM Release variation.

  • For SQL Server 2016

    You need to use SQL Server 2016 Service Pack 2 or a later upgrade. To learn more, see How to get the most recent service pack for SQL Server 2016

  • For SQL Server 2014

    You need to use SQL Server 2014 Service Pack 1 or a later upgrade. To learn more, see How to get the most recent service pack for SQL Server 2014

  • For SQL Server 2012

    You should use SQL Server 2012 Service Pack 2 or a later upgrade. For additional information, see How to acquire the current service pack for SQL Server 2012

    Note
    • Make sure that you examine recognized setup problems when you set up SQL Server 2012 on Windows 10 or Windows Server 2016.
    • The Books Online subject Hardware and Software Requirements for Installing SQL Server 2012 has actually not yet been upgraded to show the assistance for Windows Server 2016 and Windows Server 2019.
  • For SQL Server 2008 R2

    SQL Server 2008 R2 is not supported on Windows 10 or Windows Server 2016.

  • For SQL Server 2008

    SQL Server 2008 is not supported on Windows 10 or Windows Server 2016.

Minimum SQL Server variation requirements for Windows Server 2012 R2 or Windows 8.1

This area explains the minimum variation requirements for setting up SQL Server on a computer system that is running Windows Server 2012 R2 or Windows 8.1.

Before you set up SQL Server on a computer system that is running Windows Server 2012 R2 or Windows 8.1, you need to ensure that you satisfy the following minimum requirements, as suitable for your circumstance:

Like this post? Please share to your friends:
Leave a Reply

;-) :| :x :twisted: :smile: :shock: :sad: :roll: :razz: :oops: :o :mrgreen: :lol: :idea: :grin: :evil: :cry: :cool: :arrow: :???: :?: :!: