How to know How many SQL instances installed in server.

 

1) get from Registry by using this query

 

DECLARE @GetInstances TABLE

( Value nvarchar(100),

InstanceNames nvarchar(100),

Data nvarchar(100))

 

Insert into @GetInstances

EXECUTE xp_regread

  @rootkey = 'HKEY_LOCAL_MACHINE',

  @key = 'SOFTWARE\Microsoft\Microsoft SQL Server',

  @value_name = 'InstalledInstances'

 

Select InstanceNames from @GetInstances

 

 

Thanks to Mohammed Ifteqar Ahmed

 

 

 

2) Check Directory in Registry

 

- Run - Regedit - check Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\InstalledInstances - has all the instances as space delimited.


3) Got to SQL Server Configuration Manger:

- Left Side - Click "SQL Server Services" -- right side all the instances listed as SQL SERVER (InstanceName).