registery entry for mssql instances doesn't exist (but it does exist)

[orthogonous]

Hi All

Stuck with this issue so reaching out, hoping someone else has had and fixed this in the past.

windows_exporter can't find the registry key Software\Microsoft\Microsoft SQL Server\Instance Names\SQL even though it exists on the local machine. I'm assuming there's a problem with this particular windows machine but posting here in case someone has had and fixed this problem before

command prompt was run as administrator

C:\Program Files (x86)\windows_exporter>windows_exporter.exe --collectors.mssql.class-print --collectors.enabled="mssql"

time="2021-07-28T04:50:23-06:00" level=warning msg="Couldn't open registry to determine SQL instances:The system cannot find the file specified." source="mssql.go:43"

Available SQLServer Classes:

- accessmethods
- availreplica
- bufman
- databases
- genstats
- memmgr
- sqlerrors
- dbreplica
- locks
- sqlstats
- transactions

 

C:\Program Files (x86)\windows_exporter>

reg query

C:\Program Files (x86)\windows_exporter>reg query "HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL

 
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL

    REDACTED REG_SZ    MSSQL12.REDACTED
    REDACTED2 REG_SZ    MSSQL12.REDACTED2

C:\Program Files (x86)\windows_exporter>

[Buta]

Hey there,

I'm in the exact same situation, with the exact same error message.

(MSSQL Instance exists in registry, running properly, but not found by windows_exporter, everything is running as admin on a WS2019 VM)

Were you able to solve this issue?

~B