Referenced registry keys

Following is the list of registry keys referenced by PATROL for Microsoft SQL Server KM for instance discovery:

  • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
  • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ SQLServerAgent
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

When monitoring Microsoft SQL Server 2005:

  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ MSSQL.x

When monitoring Microsoft SQL Server 2008:

  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ MSSQL.x

When monitoring Microsoft SQL Server 2012:

  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x

Additional registry child keys and subkeys used:

  • HKEY_LOCAL_MACHINE\SOFTWARE\\Microsoft\Microsoft SQL Server\CurrentVersion
  • HKEY_LOCAL_MACHINE\SOFTWARE\\Microsoft\Microsoft SQL Server \MSSQLServer
  • (For cluster only) HKEY_LOCAL_MACHINE\SOFTWARE\\Microsoft\Microsoft SQL Server \Cluster
  • (For Microsoft SQL Server 2005) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\SQLPath
  • (For Microsoft SQL Server 2008) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\ClientSetup\SQLPath
  • (For Microsoft SQL Server 2012) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Tools\ClientSetup\SQLPath
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x \SQLServerAgent subkey:
    • ErrorLogFile
  • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName
  • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer_ServiceName subkey:
    • ImagePath
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer\Parameters
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Replication subkeys:
    • WorkingDirectory
    • DistributionDB

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*