We've have recently moved a SQL Server database from a local server to a dedicated server. On our local server we had maintenance plans setup to backup the database and they ran fine. The local server had SQL Server 2008 Standard Edition. However on the
dedicated server, although we can successfully set maintenance plans, they are not executing. We are getting the following error message:
"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."
The dedicated server has SQL Server 2008 Web Edition and we do not current have a spare license key for a Standard Edtion.
I have read some post on these forums that say if you install Service Pack 2 then maintenance plans will run without using Integration Services, however, we have installed Service Pack 2 and it still does not run.
So a few questions:
- other posts suggest installing the Integration Services component from the Standard Edition we have locally, but does this then become a breach of the licensing for the Web Edition?
- is it possible to purchase just the Integration Services
View Complete Post