How to Find Your SQL Server Instances or Server Name


There are several ways to find your SQL Server Instances Or Server Name. By default the SQL Server Instance Or Server name would be your system name. You can use any of the below solution to identify your SQL Server Name.

Solution 1: To Identify SQL Server Instance Name using Microsoft SQL Server Management Studio

  • 1. Start Microsoft SQL Server Management Studio.
  • 2. In the Server Name you can find your server instance or server name.
  • SQL Server Login
  • 3. If the server name field is blank, click on the dropdown
  • 4. You can find a option "<Browse for more..>" click on it.
  • 5."Browse for Server" popup window will open. Now expand the Database Engine
  • Browse for SQL Server
  • 6.Now you can find all the sql server instances or server names.
  • SQL Server Instances
  • 6.Select the sql server instance or server name and click on "OK" button.
  • 7.Selected name will be populated in the server name field.
  • 8.You can use Windows Authentication or SQL Server Authentication to connect to your SQL Server.

Solution 2: To Identify SQL Server Instance Name using Microsoft SQL Server Management Studio

  • 1. Start Microsoft SQL Server Management Studio.
  • 2. Enter period (.) in server name filed.
  • 3.You can select Windows Authentication or SQL Server Authentication in Authentication dropdown and click on "Connect" button. Once its connected to SQL Server you will see the below screen.
  • 4.Click on "New Query" and paste the below SQL syntax.
  • Select @@ServerName;
  • 5.Click on "Execute" to get the SQL Server Name.
  • SQL Server Name

Solution 3: To Identify SQL Server Instance Name using Windows Command Prompt

  • 1.Open Windows Command Prompt (Window + R, type cmd, hit enter)
  • 2.Type SQLCMD -L and hit "Enter"
  • SQL Server Instance Using Windows Command Prompt
Share On