FortiClient

Systems

Microsoft

Linux

How to Get List of Microsoft SQL Server Instances

There is multiple way to identify the Microsoft SQL Server Instance names installed in the local machine or a server. Please refer the below instructions.

1. Using Registry Editor

  • Windows+R
  • Type "regedit" and click on the "OK"
  • Go to the below path
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names
2. Using Command Prompt
  • Windows+R
  • Type "CMD" and click on the "OK"
  • Copy and paste the below command
    • reg query "HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL

3. Using Windows PowerShell
  • Windows+R
  • Type "powershell" and click on the "OK"
  • Copy and paste the below command
    • Get-ItemProperty ‘HKLM:\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL’