|This usually indicates a security issue with SLD or WSS configuration.|
The SLD site was working, but the Service Level Dashboard page element in SharePoint is generating an error.
By examining the SLD logs, located under %ProgramFiles%\Service Level Dashboard 2.0\Logs\Dashboard.log, you might also see this login failure event.
Message :System.Data.SqlClient.SqlException: Login failed for user 'OPSMGRLAB\WSSContentPoolSvc'.
Examining the SQL Server logs, you might also see these access denied events.
Login failed for user 'OPSMGRLAB\WSSContentPoolSvc'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 192.168.2.110]
This is most commonly because the the WSS Content Pool service account login wasn’t created or configured properly during the SLD installation process.
In SQL Management Studio, connect to the instance hosting the Data Warehouse database and navigate to Security > Logins. If you do not see a login for the account you specified as the WSS Content Pool service account (aka, IIS application pool identity), create the login.
A related issue is when this event is written to the SLD log.
Message :System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'GetSLADetails', database 'OperationsManagerDW', schema 'dbo'.
This is resolved by configuring the User Mappings for the WSS Content Pool service account (aka, IIS application pool identity). This account needs the SLDReader role on the Data Warehouse database.
|Here are more troubleshooting tips from our very own Raghu Kethineni. The following is a snippet from the Technet forums, and all credit goes to Raghu.|
1. Make sure the Operations 2007 reporting is upgraded to R2 reporting is upgraded.
2. As a test run the "Service Level Tacking Summary Report" and see that the data is rendered correctly.
3. Make sure you import the Service Level Dashboard 2.0 Management Pack.
4. Install SLD by Run As Administrator or Open a command prompt as an administrator (in Start menu, right-click command prompt and select Run as administrator).
5. Open ..\inetpub\wwwroot\wss\virtualdirectories\51918\web.config file
Search for callstack = “False”
Change to callstack = “true”
Search for customerror=”on”
Change to customerror=”off”
6. Execute the Dashboard and review the log file @ C:\ProgramData\Service Level Dashboard 2.0\Logs.