How to Find SQL Server Instance Name

There are multiple ways on getting the SQL Server instance name. You can refer any of below methods.

Below example were tested on SQL Server 2012 R2 version but the steps will be similar to other SQL Server versions.

Method 1

Launch the SQL Server Management Studio. You will get the Connect to Server dialog box. From here, you can obtain the instance name, which is at the Server name.

If it’s does not appear, click on Server name drill down list and click Browse for more. Once clicked, you will get below screen and you will get the instance name under the Database Engine.

Method 2

Use below query.

select @@servername

Method 3

Login to the SQL server operating system, open the command prompt and execute below command line.

sqlcmd -L

Method 4

Open the SQL Server Configuration Manager, click on SQL Server Services and double click on SQL Server (MSSQLSERVER).

Go to Service tab and you will get the instance name from here, as per below screenshot.