none
SQL installation on Windows 10 Pro

    Question

  • I have heard that SQL cannot be installed on Windows 10 Pro, but I must have Windows 10 Enterprise.  Is this true?
    Monday, January 09, 2017 11:09 PM

All replies

  • That is not true - I am running it on the home edition right now.
    Monday, January 09, 2017 11:26 PM
  • From:

    https://msdn.microsoft.com/en-us/library/ms143506.aspx

    You can install SQL 2016 Standard edition on:

    SQL Server StandardWindows Server 2016 Datacenter

    Windows Server 2016 Standard

    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

    • Proposed as answer by Olaf HelperMVP Tuesday, January 10, 2017 5:00 AM
    Monday, January 09, 2017 11:27 PM
  • Hi,

    SQL Server 2016 does support Windows 10 Pro but not all versions as per https://msdn.microsoft.com/en-us/library/ms143506(v=sql.130).aspx

    SQL Server 2014 with SP1 onwards also supports Windows 10 Pro but not all versions as per https://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx

    SQL Server 2012 with SP2 onwards is supported.

    SQL Server 2008/R2 is not supported Windows 10 Pro.

    • Proposed as answer by Olaf HelperMVP Tuesday, January 10, 2017 5:00 AM
    Monday, January 09, 2017 11:34 PM
  • Thanks
    Tuesday, January 10, 2017 12:51 AM
  • Hi metatron2,

    Despite SQL Server Enterprise and SQL Server Web, other edition can all work on the Windows 10 Professional and Windows 10 Enterprise.

    It looks like that you have get the answer of this question, if you are satisfied with their replies, could you please mark their replies as 'Answered'? This can be beneficial to other community members reading this thread.

    If you have any other questions, please let me know.

    Best Regards,
    Teige

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Olaf HelperMVP Tuesday, January 10, 2017 5:01 AM
    Tuesday, January 10, 2017 2:32 AM
    Moderator