Solved

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

Posted on 2010-08-17
4
1,292 Views
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.
0
Comment
Question by:dn_au
  • 2
  • 2
4 Comments
 
LVL 22

Expert Comment

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

http://technet.microsoft.com/en-us/l...14(WS.10).aspx

Using SQL Server in Windows Small Business Server 2008 Premium Edition
http://technet.microsoft.com/en-us/l...97(WS.10).aspx

Windows Small Business Server 2008 Repair Guide
http://technet.microsoft.com/en-us/l...85(WS.10).aspx
0
 

Author Comment

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

Accepted Solution

by:
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 :

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/96f595cc-fc40-430a-ba04-37dec4385df9
0
 
LVL 22

Expert Comment

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

830 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