Solved

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

Posted on 2010-08-17
4
1,291 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. 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.

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

A safe way to clean winsxs folder from your windows server 2008 R2 editions
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

821 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