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 Le mardi 3 août 2021 à 15:31:57 UTC+2, orthogonous a écrit : > 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> > > > -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/959620bd-a72e-4e97-93d3-e8214075c823n%40googlegroups.com.
