How to find List of SQL Server Instances Installed on a Machine?

There are multiple ways by which we can find a list of SQL Server instances Installed on a Machine.

1. Using Command Prompt(cmd)

Whenever SQL Server is installed, there will be an entry in the Windows registry key. So we can query the registry key to find details about the instance name.

reg query "HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL

2- Using PowerShell

Whatever method we did on Method 1, it can also be obtained using the PowerShell. Below is the method where we query in the registry.

Get-ItemProperty ‘HKLM:\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL’

Leave a Reply

Your email address will not be published. Required fields are marked *