Solved

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

Posted on 2010-08-17
4
1,294 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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 …

617 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