After installing MS SQL 2008 on a SBS Premium Server, cannot run reports no SBSMonitoring instance

Posted on 2010-08-17
Medium Priority
Last Modified: 2012-05-10
We are in the process of configuring a new Windows 2008 SBS Premium HP Server.  When we installed the Microsoft SQL Server 2008 we could not keep the SQL Express 2005 Viewer.  We attempted to try to upgrade the SBS SQL Express 2005 SBSMonitoring database but this did not work, so we installed SQL Server 2008 and afterwards cannot access or create reports within the SBS Console.

Errors occur when refreshing the SBS Console in Reports states "There was an error while loading data for this page" and when we attempt to Add New Report and save we get the error "The report properties cannot be saved. Reopen the report properites dialog, and try again".

Within the Services there does not appear to be a SQL service for the reporting SBSMonitoring agent.  

There does not appear to be any databases that I can find easily to upgrade either, does anyone know the default location ?

Anyway, we now have a server which does not have a SBSMonitoring instance or database that can be seen within the 2008 SQL server consoles.  Is there a way of installing this component of the server again ?   We would prefer to have the SBSMonitoring instance live within the 2008 SQL environment if possible. If this is not possible how can this instance or situation be fixed.

We were hoping to deploy the server this weekend (21st Aug 2010). Any help provided would be appreciated.
Question by:dn_au
  • 2
  • 2
LVL 22

Expert Comment

by:Rick Hobbs
ID: 33461208
Please check these links:


Using SQL Server in Windows Small Business Server 2008 Premium Edition

Windows Small Business Server 2008 Repair Guide

Author Comment

ID: 33467643
I cannot use any of the links you have provided all come up with errors with page bad request.

Accepted Solution

dn_au earned 0 total points
ID: 33468776
We decided to reload from scratch.  This link helped during the installation of MS SQL 2008 Server :

LVL 22

Expert Comment

by:Rick Hobbs
ID: 33503243
Damn, it looks like the links got truncated when I copied and pasted them.

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question