Skip to main content
Installation and data management

Find out which SQL version is being used

Use the System Information portlet

  1. Open the application.
  2. Select
    View > Home Dashboard
    .
  3. If the
    System Information
     portlet is not currently available on any tabs in the dashboard, select
    Add View
    .
  4. In the
    Description
     field, enter System Information and then select
    OK
    .
  5. Select the
    Select Portlets
     link.
  6. Mark the
    System Information
     checkbox and select
    OK
    .
  7. Find the
    SQL version
     row, and your SQL server information is listed there.
    tip
    The
    Database server
     row indicates which SQL instance is being used.

Use the SQL Server Installation Center

  1. At the SQL Server, use the Start menu to search for and open the SQL Server Installation Center.
  2. In the left pane of the SQL Server Installation Center window, select
    Tools
    .
  3. In the right pane, select
    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.
  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.

Use the Windows Command Prompt

  1. At the workstation where SQL is installed, select
    Start > Run
    , and enter
    cmd
     in the
    Open
     field. Select
    OK
     to open a command prompt window.
  2. In the command prompt, enter
    SQLCMD -S servername\instancename
    . The command prompt will change to
    1>
    1. To find the SQL instance name, type
      services.msc
       in a new command prompt window.
    2. Find the entries beginning with SQL. The instance name is listed in parenthesis.
  3. Type
    select @@version
     and press Enter.
  4. At the
    2>
     prompt, enter
    go
     and then press Enter.
  5. The SQL version running on this workstation is displayed. If you have multiple instances, you can repeat these steps for each instance.
note
If FileCabinet CS is reporting that you are using SQL Express, but you believe that the instance is using a full version of SQL, you can open the instance in SQL Server Management Studio and enter the following query to determine which edition is being reported by SQL:
sqlcmd -Sservername -q"select SERVERPROPERTY('edition')"
.

This article applies to:

  • Product: Workpapers CS
  • Subject: SQL

Related Content