No Data in Metrics Reports

Article ID: RPT0002 Metrics reports viewed in Web Console contain no data because of a failed connection to the CVCloud database.

Symptom

On a Web Console that is hosted by a computer installed with Private Metrics Reporting Server and Microsoft SQL Server 2012, Metrics reports display no data.

Cause

Microsoft SQL Server 2012 fails to connect to the CVCloud database. In SQL Server 2012, the built-in NT AUTHORITY\SYSTEM account no longer has the sysadmin privilege by default. SQL Server 2012 introduced an additional per-service SID (Security Identifier) for the Microsoft VSS writer and WMI services with a sysadmin role.

Resolution

Add sysadmin privileges to the Local System account.