Missing data in Metrics view for the sqlserver probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Operator Console Metrics Views do not display any data for the sqlserver probe even though the probe is not reporting any alarms

Error captured in the sqlserver_monitor.log for all metrics being collected

sqlserver: Value of error Permission denied and error no. 13
sqlserver: SetNamedSecurityInfo failed: 5

Environment

Any sqlserver probe version

Cause

sqlserver prerequisites are not fulfilled

Resolution

This issue is seen when Windows user configured in sqlserver probe does not have the required access to the ..\nimsoft\niscache folder on the system where the sqlserver probe is installed.

See sqlserver Access Prerequisites