How do I determine which version or edition of Microsoft® SQL Server is installed for CCH® ProSystem fx® Engagement or Workpaper Manager?

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)

For more information, see how to determine the version and edition of SQL Server and its components.

 

  Solution Tools
  Attachments
 Solution Id 000031343/sw1873
 Direct Link
To provide feedback on this solution, please login.

Your feedback about this article will help us make it better. Thank you!