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:
- Press Windows Key + S.
- Enter SQL Server Configuration Manager in the Search box and press Enter.
- Or locate the Microsoft Management Snap-in Console in one of the following locations:
- SQL Server 2019
- C:\Windows\SysWOW64\SQLServerManager15.msc
- SQL Server 2017
- C:\Windows\SysWOW64\SQLServerManager14.msc
- SQL Server 2016
- C:\Windows\SysWOW64\SQLServerManager13.msc
- SQL Server 2014 (12.x)
- C:\Windows\SysWOW64\SQLServerManager12.msc
- SQL Server 2012 (11.x)
- C:\Windows\SysWOW64\SQLServerManager11.msc
- SQL Server 2019
- Or locate the Microsoft Management Snap-in Console in one of the following locations:
-
In the top-left frame, click to highlight SQL Server Services.
-
Right-click SQL Server (PROFXENGAGEMENT) and click Properties.
-
Click the Advanced tab.
-
Browse to Stock Keeping Unit Name and Version.
- 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)
-
SQL Server 2019:
- SQL Server 2019 (15.0.2080.9 - January, 2021)
For more information, see how to determine the version and edition of SQL Server and its components.
Solution Id | 000202978/sw1873 |
---|---|
Direct Link |