March 11, 2008 at 2:34 pm
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
March 11, 2008 at 8:39 pm
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.
March 5, 2009 at 5:17 am
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