Solved

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

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

Scale it in WD Gold

With up to ten times the workload capacity of desktop drives, WD Gold hard drives employ advanced technology to deliver among the best in reliability, capacity, power efficiency and performance.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
A procedure for exporting installed hotfix details of remote computers using powershell
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 show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now