When you open the SBS console and go to the Reports part. You receive the following error: “There was an error while loading data for this page.”
Also no Reports or information is showed and the Add a new report isn’t clickable after closing the error message.
When you take a look at the C:\Program Files\Windows Small Business Server\Logs\Console.log you see the following message:
 110302.203758.5574: Exception:
An exception of type ‘Type: System.Data.SqlClient.SqlException, System.Data, Version=18.104.22.168, Culture=neutral, PublicKeyToken=b77a5c561934e089’ has occurred.
Timestamp: 03/02/2011 20:37:58
Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)
Stack: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at Microsoft.WindowsServerSolutions.SystemHealth.Monitoring.MonitoringSQLDataStore.GetAlertCountPerType(ComputerType type)
Solution: It looks like the SBSMonitoring SQL Server instance is by default on disabled.
Go to Administrative tools, services and change the startup type to Automatic and start the service.