SCE 2007: Configuring on SBS 2003 R2 Premium Edition - SQL Workgroup?? or should we install to the Express Instance and be done?
When I asked around about issues people have had deploying SCE 2007 on SBS 2003 R2 Premium, I was told there were some issues with SQL Server (2005 Workgroup Edition). I have not been able to collect the exact issues because many of the people are working from memory.
I do know that running SCE 2007 on SBS 2003 R2 Premium DOES work with the Express Database that ships with System Center Essentials 2007, and to be honest this really should be good enough given the cap of 75 Devices in SBS 2003 and the number of dedicated SQL Instances that get installed on an SBS Build. So what's one more in the scheme of things?
The Installing SQL Server 2005 WorkGroup Edition in Windows Small Business Server 2003 R2 Document says:
- Do not upgrade the instance of MSDE that is installed for Monitoring (MSSQL$SBSMONITORING), because this it is not supported.
- Do not upgrade the instance of MSDE that is installed for Update Services (MSSQL$WSUS), because this is not supported.
and the Installation of ISA Server 2004 adds a (Microsoft ISA Server 2004 instance).
I am very much in favour of doing an upgrade of the MSSQL$SHAREPOINT instance to SQL 2005 Workgroup Edition so that Full Text Search is enabled for Windows Sharepoint Services, but if I didn't have a line of business application that needed SQL Server 2005 Workgroup then I wouldn't be installing a Default Instance just because I could.