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’