Currently have a client that is using SBS 2003 first release with some of its database on SQL 2000. They are implementing some new hardware and as part of this will be migrating to SBS 2003 R2 which obviously includes SQL 2005 Workroup edition rather than SQL 2000.
On thieir current setup theu have had Analysis and Integration Services added to the standard setup to allow a certain bit of software to function for reporting purposes.
The problem arises with SQL 2005 Workgroup edition not including these services which are essentialo to this piece of software.
Basically is there any way of adding these services to SQL 2005 workgroup edition or are they totally stumped and will have to upgrade to SQL 2005 Standard. Or is there an upgrade path from the workgroup edition included in SBS2003 to the full blown SQL 2005?
Thanks in advance.