Home Forums SQL Server 2005 Administering How to find out Installed SQL Server Instances on a server RE: How to find out Installed SQL Server Instances on a server

  • September 18, 2011 at 3:13 am

    #1383052

    Hi,

    Get SQL server information in OS registry levels.

    Irrespective of the version of SQL Server, information is saved in the registry. Only the location changes for various versions. The path in the registry is as follows.

    SQL Server Default Instance(2000)

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup

    SQL Server Default Instance(2005)

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

    SQL Server Named Instance (2008)

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.ONE\Setup

    Best Regards,

    Rama Udaya.K