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

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.
dn_auAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rick HobbsRETIREDCommented:
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
dn_auAuthor Commented:
I cannot use any of the links you have provided all come up with errors with page bad request.
0
dn_auAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rick HobbsRETIREDCommented:
Damn, it looks like the links got truncated when I copied and pasted them.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.