Network Management

How to identify the SQL Server version and edition for the Orion database

This article describes how to identify the Microsoft SQL Server database software edition and version of the Orion database.

First published date

10/11/2018 3:08 PM

Last published date

3/23/2022 5:02 AM

Overview

This article describes how to use a command prompt to identify the Microsoft® SQL Server® database software edition and version used for the Orion database.

Product section

Orion Platform

Cause

n/a

Resolution

Log in to the Windows SQL Server

Open an RDP session to your MS SQL server where the SolarWinds Orion database is stored.

  1. Open a command prompt window.
  2. Execute the following command:
    SQLCMD -S servername\instancename
    where servername is your server name and instancename is the SQL instance name.
  3. Enter select @@version and press <Enter>.
  4. At the 2 > prompt, type go and press <Enter>.
    The SQL version running on the server displays in the dialog box.
  5. Repeat step 3 through step 5 for each additional instance. 

Identify the SQL Server instance name 

If you cannot remember the instance name, perform the following steps:

  1. Open a command prompt window.
  2. Execute: 
    services.msc
  3. Scroll down to entries beginning with SQL.
  4. Locate an entry for each installed named SQL Server (instancename).
    The value in parenthesis is the instance name.
See also Determine the version, edition, and update level of SQL Server and its components (© 2021 Microsoft Corp., available at https://docs.microsoft.com/, obtained on April 23, 2021).