How To Determine The Version And Edition Of SQL Server And Its Components

SQL Server Management Studio (SSMS)

To determine the version of the client tools that are installed on your system, start Management Studio and then click "About" on the Help menu.

SQL Server

How to determine which version of SQL Server Database Engine is running.

To determine the version of SQL Server, you can use any of the following methods:

Method 1

In SQL Server Management Studio.

Click on File at top left, then connect to the Server by clicking on Connect Object Explorer. A login window will now open. On this window the version information is mentioned - Ex: Microsoft SQLServer 2016.

Method 2

By the Errorlog file for that instance.
 
The error log is located at C:\Program Files\Microsoft SQL Server\MSSQL13.SQLSERVER2016\MSSQL\Log. The entries may resemble the following:

2017-07-31 17:04:04.27 Server      Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)   Oct 28 2016 18:17:30          Copyright (c) Microsoft Corporation    Developer Edition (64-bit) on Windows 10 Pro 6.3 <X64> (Build 14393: )

As you can see, this entry gives all the necessary information about the product, such as version, product level, 64-bit versus 32-bit, the edition of SQL Server, and the OS version on which SQL Server is running.

Method 3

Connect to the instance of SQL Server, and then run the following query:

Select @@version

An example output of this query is as follows:

Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Apr 29 2016 23:23:58 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 6.3 <x64> (Build 14393: )

Method 4

Connect to the instance of SQL Server, and then run the following query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Note

This query works with any instance of SQL Server 2000 or later.

Method 5

Starting with SQL Server 2008, you can also use the Installed SQL Server Features Discovery report. This report can be found by locating the Tools page of SQL Server Installation Center. This tool gives you information about all the instances of SQL Server that are installed on the system. These include client tools such as SQL Server Management Studio. The only thing to be aware of is that this tool can be run locally however only on the system where SQL server is installed. It cannot be used to obtain information about remote servers. For more information, visit the following blog post on the Microsoft Developer Network (MSDN)

SQL Server Business Intelligence Development Studio (BIDS)

To check the version of Analysis Services Designer, of Integration Services Designer, or of SQL Server Reporting Services Designer, follow these steps:

  1. Under your SQL program group, start SQL Server Business Intelligence Development Studio.
  2. On the Help menu, click About.
  3. In the Installed products-list, select the required component and then notice the version that is given under the Product details text box.

Visual Studio 2015 to check version

SQL Server

SQL Server / SQL Server R2 / Visual Studio 2015

SQL Server

Note

For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and/or hotfixes on the client-side computers to obtain the latest fixes while developing SSIS packages, SSRS reports, or Analysis Services cubes.

SQL Server

Ref