The official blog for Windows Server Essentials and Small Business Server support and product group communications.
EPS Team Blogs
As more and more people are installing SQL 2005 WE, we wanted to refresh and clarify a few points and concerns. These are most likely addressed here and there, scattered around the Internet, so hopefully we can provide a quick way of getting to all of them.
The first thing we want to address is the lack of in-place upgrades from SQL 2000 Standard to SQL 2005 Workgroup Edition, if you need an instance to be SQL 2005 WE, you will need to migrate it. This is a limitation of SQL 2005 WE.
The upgrade matrix for SQL products is found here: http://msdn2.microsoft.com/en-us/library/ms143393.aspx
In order to migrate your instances, you will need to consult the line of business vendor for proper migration steps (and to confirm support for SQL 2005 WE). From a technical perspective the steps are pretty straightforward, but there are always gotchas. Make sure you test the migration in your test environment before deploying in production.
Please note that this overview is not designed as a comprehensive walk-through of the migration process. Your particular line-of-business application may require additional steps.
Migration of your SharePoint v2 (WSS v2) instance is described in this document: http://download.microsoft.com/download/4/0/8/40860507-c351-4308-a876-e1b83ee4e77a/sqlinstallsteps.htm
This document also discusses (with different levels of detail) the following topics:
Finally, you might want to use all of the SBS 2003 R2 features but still keep your SQL 2000 STD instance, for information on your downgrade rights please see the SBS 2003 SQL FAQ: http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/bizsolutions.mspx
The Official SBS Blog : Installation Options for SQL 2005 Workgroup Edition in SBS 2003 R2 Premium: http