Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Tuesday, March 4, 2014

Error on SQL Server 2005: "Create maintenance plan failed"

The cause of this error is lack of  Integration Services (SSIS) service when installing SQL server 2005.

When you create the maintenance plan, the following code is run.
EXEC msdb.dbo.sp_update_jobstep @job_name=N'System DB Maintenance Plan', @step_id=1 , @subsystem=N'SSIS', @command=N'/SQL 
"\Maintenance Plans\System DB Maintenance Plan" /SERVER ASHBSQL701 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF'
This code tries to access the Integration Services service.
The solution is to install back the Integration Services from the SQL server 2005 setup CD


Ref: http://support.microsoft.com/kb/909036

Thursday, December 12, 2013

SQL 2012SP1 installation error Error code 0x84B20001

have error found when install MS SQL 2012SP1, the source downloaded from here
the error message is :
The patch file cannot be opened. The file is: D:\PCUSOURCE\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msp.
Error code 0x84B20001

* where D is your CD ROM drive letter.

Google it with the Error code and found the post in MSDN:

http://social.msdn.microsoft.com/Forums/silverlight/en-US/18806293-ac9a-472e-aaba-5d862ad4b857/sql-server-enterprise-core-2012-sp1-setup-failure

Tried to extract the whole ISO and the server local drive but still fail, Re-download the ISO file solve the issue. The Tech net download site seems not stable as before !! ب_ب