I'm seeing the following. Tried to repair the managemement server install and reporting role but no luck. Please provide the following information to the support engineer if you have to contact Microsoft Help and Support : Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderException: An error occurred executing the command: [Microsoft.EnterpriseManagement.Presentation.DataProviders.Library!NetworkDashboardProvider/GetCurrentTopNodesByPerformance] in provider: [Microsoft.EnterpriseManagement.Presentation.DataProviders.NetworkDashboardProvider, Microsoft.EnterpriseManagement.Presentation.DataProviders.Library, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]. : Unable to execute stored procedure needed for dashboard. If you just installed Operations Manager Reporting Server, please wait a while and try again. This can also occur if the Operations Manager Reporting Server SQL Server is not started or inaccessible. ---> Microsoft.EnterpriseManagement.Presentation.DataProviders.DataWarehouseException: Unable to execute stored procedure needed for dashboard. If you just installed Operations Manager Reporting Server, please wait a while and try again. This can also occur if the Operations Manager Reporting Server SQL Server is not started or inaccessible. ---> Microsoft.EnterpriseManagement.Common.UnknownDatabaseException: The EXECUTE permission was denied on the object 'Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2', database 'OperationsManagerDW', schema 'sdk'. at Microsoft.EnterpriseManagement.Common.Internal.ServiceProxy.HandleFault(String methodName, Message message) at Microsoft.EnterpriseManagement.Common.Internal.MonitoringDataWarehouseServiceProxy.GetDataWarehouseStoredProcedureResult(String SpName, StoredProcedureParameterCollection param, IEnumerable`1 columnFilter, Int32 timeout) at Microsoft.EnterpriseManagement.Warehouse.DataWarehouse.GetDataWarehouseData(String storedProcedureName, StoredProcedureParameterCollection param, IEnumerable`1 columnFilter, Int32 timeout) at Microsoft.EnterpriseManagement.Presentation.DataProviders.NetworkDashboardProvider.GetCurrentTopNodesByPerformance(DateTime startDateTime, IDataObject performanceCounterArray, Boolean sortAscending, Int32 numEntities) --- End of inner exception stack trace --- at Microsoft.EnterpriseManagement.Presentation.DataProviders.NetworkDashboardProvider.GetCurrentTopNodesByPerformance(DateTime startDateTime, IDataObject performanceCounterArray, Boolean sortAscending, Int32 numEntities) --- End of inner exception stack trace --- at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command) at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.ExecuteInternal[TResult](DataCommand command) at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.<ExecuteAsync>b__0[TResult](<>f__AnonymousType0`1 data)

I see that you are getting an access denied on the OperationsManagerDW when you try to run the Excecute on the object 'Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2' Log on to the SQL server hosting the dbase and check the error log whether theres a particular account that has an audit failure. If yes, assign that account the rights to execute the stored procedure on your OperationsManager DW dbase and try again. Maybe post the additional logging of the sql server. If you need more info please do not hesitate to reply.It's doing common things uncommonly well that brings succes.

I see that you are getting an access denied on the OperationsManagerDW when you try to run the Excecute on the object 'Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2' Log on to the SQL server hosting the dbase and check the error log whether theres a particular account that has an audit failure. If yes, assign that account the rights to execute the stored procedure on your OperationsManager DW dbase and try again. Maybe post the additional logging of the sql server. If you need more info please do not hesitate to reply.It's doing common things uncommonly well that brings succes.

Try following: 1. make sure that the datareader and data writer account has required right on data warehouse and operation manager DB http://technet.microsoft.com/en-us/library/hh298609.aspx 2. Make sure that password is not expire on data reader and data writer account Roger

Try following: 1. make sure that the datareader and data writer account has required right on data warehouse and operation manager DB http://technet.microsoft.com/en-us/library/hh298609.aspx 2. Make sure that password is not expire on data reader and data writer account Roger