Castell Computers

MSSQL Server 2008 Workgroup Edition is shipping with GoldMine 8.5 purchases (including upgrades!) now. With it, one would expect to be able to run the typical database maintenance and backup routines on their SQL server. Unfortunately, there was a bit of a problem with that and some users were caught unaware. Fortunately, the programmers at Microsoft have corrected the problem with service pack 1. If you run SQL 2008 Workgroup Edition, it’s not an option — get it!

From Microsoft Knowledgebase article 968382:

PROBLEM
Consider the following scenario. You install the release version of one of the following editions:

* Microsoft SQL Server 2008 Standard x86 or x64 edition
* Microsoft SQL Server 2008 Developer x86, x64, or IA-64 edition
* Microsoft SQL Server 2008 Enterprise x86, x64, or IA-64 edition
* Microsoft SQL Server 2008 Workgroup x86 or x64 edition
* Microsoft SQL Server 2008 Web x86 or x64 edition

You install the SQL Server 2008 Client Tools. However, you do not have SQL Server 2008 Integration Services installed. When you create and then execute a maintenance plan, you receive the following error message in the job history:
The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services. The package execution failed. The step failed.

RESOLUTION
Service pack information To resolve this problem, obtain the latest service pack
Service pack information
To resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
968382 How to obtain the latest service pack for SQL Server 2008

Cumulative update information
The fix for this issue was first released in Cumulative Update 3. For more information about how to obtain this cumulative update package for SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:
960484 Cumulative update package 3 for SQL Server 2008
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
956909 The SQL Server 2008 builds that were released after SQL Server 2008 was released