Help and Support
Search
Search Topics Help and Support.

This article applies to:

  • Product: Companies House Accounts Filing,Digita Accounts Production,Digita Accounts Production Advanced,Digita Company Secretarial,Digita Corporation Tax,Digita Corporation Tax Advanced,Digita Personal Business and Trust Tax,Digita Practice Management

Find your SQL Server version and edition for Digita Suite

Using the About menu

  1. Open Accounts Production, Practice Management, or Company Secretarial.
  2. Select Help, then About.
  3. On the General tab, the first number corresponds to the SQL version being used.
SQL build numbers and versions
Build number
SQL version
11.xx
SQL 2012
12.xx
SQL 2014
13.xx
SQL 2016
14.xx
SQL 2017
15.xx
SQL 2019
important
After 12 July 2022, Microsoft will no longer support SQL Server 2012 or earlier.

Using the SQL Server Installation Center

Use the following steps to view all installed instances of SQL and related information.
  1. At the SQL Server, use the Start menu to search for and launch the SQL Server Installation Center.
  2. In the left pane of the SQL Server Installation Center window, choose Tools.
  3. In the right pane, choose Installed SQL Server features discovery report.
  4. The report opens in your default web browser. You can use this report to determine your SQL Server instance name, version, edition, and more information.
  5. Use this Microsoft help article and the number in the Version column on the report to determine if your instance is the most current version.

Using the Windows Command Prompt

Use the following steps from the command prompt to determine what version of SQL you're running.
  1. On the workstation where SQL is installed, select Start, then Run.
  2. Enter
    cmd
     in the Open field, and then press Enter on your keyboard to launch a command prompt window.
  3. Enter
    SQLCMD -S servername\instancename
     (where servername is the name of your server, and instancename is the name of the SQL instance).
    1. If you're unsure of the name of your SQL instance, open a new command prompt window and type
      services.msc
       and then press Enter.
    2. Scroll to the entries beginning with SQL Server (<instancename>)
  4. The cmd prompt will change to 1>. Type
    select @@version
     and then press Enter.
  5. The cmd prompt will change to 2>. Type
    go
     and then press Enter.
The SQL version that is running on your workstation/server is displayed. If you have multiple instances, you can repeat the process for each instances.