Monitoring and Reporting in Windows Small Business Server 2008 doesn’t work

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:

[9224] 110302.203758.5574: Exception:
An exception of type ‘Type: System.Data.SqlClient.SqlException, System.Data, Version=, 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 System.Data.SqlClient.SqlConnection.Open()
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.

Posted in Blog, SBS 2008 by ronnypot at March 3rd, 2011.
Tags: ,

Leave a Reply

Sharing Buttons by Linksku