MS SBS 2003 R2
Additiional Server Apps:
Microsoft Sharepoint (using SQL 2005)
Microsoft CRM (using SQL 2005)
Microsoft Dynamics GP Accounting (using SQL 2005)
Recently (before I came aboard) the company's accountant uninstalled SQL 2000 in an effort to upgrade to SQL 2005 to run both MS CRM and MS Dymanics.
This of course broke WSUS, SBSMonitoring and Sharepoint. I upgraded the sharepoint instance to SQL 2005 without any problems.
I would like to get WSUS and SBSMonitoring repaired.
After a bit of research, I found that MS does not support upgrading SBSMonitoring or WSUS to SQL 2005.
Should I re-install SQL 2000 (along side SQL 2005) and if so, what is the best way to do it?
Would it be better to upgrade SBSMonitoring or WSUS to SQL 2005?
My constraints are:
Not loosing the CRM, GP Dymanics and Sharepoint SQL 2005 databases.
I do not have a second box to test with.
Any suggestions would be greatly appreciated.
Thanks in advance.