Commerce Server 2007 with Service Pack 2 installed is now officially supported running on SQL Server 2008. Unless you are using Data Warehouse and Analytics, there are no special steps or requirements.
If you are using Data Warehouse and Analytics, there are a couple of things you have to do to get this to work. Since the original post, we have discovered that there is a bit more too this, unfortunately, depending on your configuration and how you installed SQL2008 (upgrade versus new install).
To get DW.up to unpack successfully you must first install the following items from the SQL Server 2005 Feature Pack December 2008 release on the SQL 2008 Server in the following order.
- Microsoft SQL Server Native Client
- Microsoft SQL Server 2005 Management Objects Collection
- Microsoft ADOMD.NET
- Microsoft SQL Server 2005 Backward Compatibility Components
- SQL Server 2000 DTS Designer
To get the SQL 2000 DTS Designer to open from SQL Server Studio Management you need to move all SQL 2008 entries in the PAT environment variable to the end of the PATH statement.
ReportInstaller.exe will not connect to the SQL Server 2008 Reporting Services to install the reports as it uses a deprecate end point web service that is no longer present. The end point web service was deprecated in SQL Server 2005 as it was a originally from SQL 2000 and SQL Server 2005 only had it present for backwards compatibility. To resolve this issue we need to make code changes to ReportInstaller.exe to do the following:
- If you are using SQL Server 2000 or 2005, then use the existing end point web service location
- If you are using SQL Server 2008, then use the new end point web service location
The report files (RDL) are not compatible with SQL Server 2008 Reporting Services. To update the reports, each report will need to be opened in Visual Studio 2008 under a Report project. When opened, each report will be updated, so that it can be saved in the new format. However, if the reports are already installed on SQL Server 2005 and the server is upgraded to SQL Server 2008 the reports will automatically get updated during the upgrade process.
We will be updating this withe the pending release documentation set for Commerce Server 2009.
Hope this helps!