Return
-
Title
When looking at details collected for a SQL Server instance it is showing as unavailable -
Description
Some details within the Foglight UI console for SQL Server instances using SQL 2008, we are seeing the status unavailable for some collected details, yet the same detaills show okay with SQL Sever instances that are at version SQL 2005.
-
Cause
The problem is a permissions issue. -
Resolution
From SQL 2008 onwards, to collect the details required the SQL Server user account being used by Foglight needs to have the Sysadmin privilege granted to it so that the details can be seen within the Foglight UI comsole.