Description: Integration Services evaluation period has expired.

  • Initially I installed evaluation copy of enterprise edition of SQL Server 2005, later we purchased the full license for the SQL Server and I did register the SQL Server 2005. Somehow the Managment Studio still says evaluation copy. And now after 180 days I installed the evaluation copy, I can't start up the Management Studio which don't allow me, this is expected since it says evaluation copy before. The SQLS erver still functioning OK.

    We also have scheduled maintenance plan nightly to backup the user database and now it failed because it says "Description: Integration Services evaluation period has expired.". Has anyone has any idea how to resolve this so I can backup my database again?

    Here's the error message I got:

    Error: 2008-03-09 03:00:00.59 Code: 0xC0000033 Source: MaintenancePlan - Backup All System DBs Description: Integration Services evaluation period has expired. End Error Error: 2008-03-09 03:00:00.60 Code: 0xC0000033 Source: MaintenancePlan - Backup All System DBs Description: Integration Services evaluation period has expired. End Error Could not execute package because of error 0xC0000033. Started: 3:00:00 AM Finished: 3:00:00 AM Elapsed: 0.344 seconds. The package execution failed. The step failed.

    Thanks,

    Matt

  • Do you have change to read the following articles?

    http://msdn2.microsoft.com/en-us/library/ms143393.aspx

    http://support.microsoft.com/kb/281574

    If they do not help, you may try to uninstall your existing SQL Server, and re-install it.

  • I had a similar issue with SSIS and fixed it by doing the following, am assuming I caused my own problem as during initial setup the install failed on Client Components, the only workaround I could find was to install them from the Eval edition, all other components were installed from the enterprise edition. Look at the following file to positively identify what is evaluation etc.

    c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\hotfix\summary.txt

    Products Detected Language Level Patch Level Platform Edition

    Setup Support Files ENU 9.2.3042 x86

    Database Services (MSSQLSERVER) ENU SP2 2005.090.3042.00 x86 ENTERPRISE

    Reporting Services (MSSQLSERVER) ENU SP2 9.00.3042.00 x86 ENTERPRISE

    Integration Services ENU RTM 9.00.1399.00 x86 ENTERPRISE

    SQL Server Native Client ENU 9.00.3042.00 x86

    Client Components ENU SP2 9.2.3042 x86 EVAL

    MSXML 6.0 Parser ENU 6.10.1129.0 x86

    Backward Compatibility ENU 8.05.2004 x86

    Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86

    This file identified my SSIS as Enterprise, only Client Components showed as EVAL

    Fix Process:

    1) Run Add/Remove programs control panel

    2) Change "Microsoft SQL Server 2005"

    3) Remove SSIS

    4) Repeat the above and this time re-add SSIS

    5) Run latest SP update

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply