SQL Server (Version)

To check the version and edition of Microsoft® SQL Server on a machine:
  1. Press Windows Key + S.
  2. Enter SQL Server Configuration Manager in the Search box and press Enter.
  3. In the top-left frame, click to highlight SQL Server Services.
  4. Right-click SQL Server (PROFXENGAGEMENT) and click Properties.
  5. Click the Advanced tab.
  6. Browse to Stock Keeping Unit Name and Version.
  1. Stock Keeping Unit Name will be the edition of SQL. Compare the displayed Version to the list below to find the version and service pack.
  • SQL Server 2008:
    • SQL Server 2008 Service Pack 4 (10.00.6000.29)
    • SQL Server 2008 Service Pack 3 (10.00.5500.00)
    • SQL Server 2008 Service Pack 2 (10.00.4000.00)
  • SQL Server 2008 Service Pack 1 (10.00.2531.00)
  • SQL Server 2008 RTM (10.00.1600.22)
  • SQL Server 2008 R2:
    • SQL Server 2008 R2 Service Pack 3 (10.50.6000.34)
    • SQL Server 2008 R2 Service Pack 2 (10.50.4000.0)
    • SQL Server 2008 R2 Service Pack 1 (10.50.2500.0)
    • SQL Server 2008 R2 RTM (10.50.1600.1)
  • SQL Server 2012:
    • SQL Server 2012 Service Pack 2 (11.0.5058.0)
    • SQL Server 2012 Service Pack 1 (11.00.3000.00)
    • SQL Server 2012 RTM (11.00.2100.60)
  • SQL Server 2014:
    • SQL Server 2014 Service Pack 1 (12.0.4100.1)
    • SQL Server 2014 RTM (12.0.2000.80)
  • SQL Server 2016:
    • SQL Server 2016 SP2 (13.0.5026.0 – April 2018)    
    • SQL Server 2016 SP2 (13.0.5233.0 – November 2018)
    • SQL Server 2016 SP1 (13.0.4541.0 – November 2018)
    • SQL Server 2016 RTM (13.0.2216.0 – November 2017)
  • SQL Server 2017:
    • SQL Server 2017 (14.0.3045.24 – October 2018)