Database Maintenance Plan dies with error 0x800401F3

[Database Administrator]

I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
instead of my home-grown utility to run Check Database commands. I used the
wizard to create the plan and used the SQL Server Agent account, which has
sysadmin rights for now. When the job runs, it dies with the error:

Executed as user: mydomain\username. Microsoft (R) SQL Server Execute
Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
Corp 1984-2005. All rights reserved. Started: 11:47:22 AM Could not
create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
failed. The step failed.

I can't find any documentation on 0x800401F3. Any ideas? Thanks!

[Database Administrator]

There could be more detailed info if you right click on the Maintanence Plan
and click View History? (I'm note sure if you got the error message you
mentioned in your post from View History or not?)

--
Ekrem Önsoy



"Jeff" wrote in message
newsFEB0C82-CA48-489B-BCFC-D6EC3D125FB7@microsoft.com...
>I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
> instead of my home-grown utility to run Check Database commands. I used
> the
> wizard to create the plan and used the SQL Server Agent account, which has
> sysadmin rights for now. When the job runs, it dies with the error:
>
> Executed as user: mydomain\username. Microsoft (R) SQL Server Execute
> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> Corp 1984-2005. All rights reserved. Started: 11:47:22 AM Could not
> create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
> Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
> failed. The step failed.
>
> I can't find any documentation on 0x800401F3. Any ideas? Thanks!

[Database Administrator]

Jeff,

Here are some discussions for you to check out. Hope that one helps

http://p2p.wrox.com/topic.asp?TOPIC_ID=43327 Read the last post for this
one.
http://www.experts-exchange.com/Web_..._21769758.html
http://forums.microsoft.com/MSDN/Sho...61588&SiteID=1

RLF

"Jeff" wrote in message
newsFEB0C82-CA48-489B-BCFC-D6EC3D125FB7@microsoft.com...
>I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
> instead of my home-grown utility to run Check Database commands. I used
> the
> wizard to create the plan and used the SQL Server Agent account, which has
> sysadmin rights for now. When the job runs, it dies with the error:
>
> Executed as user: mydomain\username. Microsoft (R) SQL Server Execute
> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> Corp 1984-2005. All rights reserved. Started: 11:47:22 AM Could not
> create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
> Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
> failed. The step failed.
>
> I can't find any documentation on 0x800401F3. Any ideas? Thanks!

[Database Administrator]

The wrox thead recommended registry changes for IUSR. Which one? Repeat for
every domain controller?

The msdn thread below implies that you can only use SQL Security, not
integrated security, with a maintenance plan. Is that right? I have other
Agent jobs that use integrated security with no trouble. The user is
sysadmin and a domain administrator (as a test to see if that solved the
problem), so I don't know how much more privilege I can throw at it.

Most of these seem to be related to ASP pages. I'm not clear how that ties
in to a Database Maintenance plan. Or is it a problem with how Microsoft is
building the plan?

I appreciate the help - I just feel a little lost still. Thanks!

Jeff

"Russell Fields" wrote:

> Jeff,
>
> Here are some discussions for you to check out. Hope that one helps
>
> http://p2p.wrox.com/topic.asp?TOPIC_ID=43327 Read the last post for this
> one.
> http://www.experts-exchange.com/Web_..._21769758.html
> http://forums.microsoft.com/MSDN/Sho...61588&SiteID=1
>
> RLF
>
> "Jeff" wrote in message
> newsFEB0C82-CA48-489B-BCFC-D6EC3D125FB7@microsoft.com...
> >I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
> > instead of my home-grown utility to run Check Database commands. I used
> > the
> > wizard to create the plan and used the SQL Server Agent account, which has
> > sysadmin rights for now. When the job runs, it dies with the error:
> >
> > Executed as user: mydomain\username. Microsoft (R) SQL Server Execute
> > Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> > Corp 1984-2005. All rights reserved. Started: 11:47:22 AM Could not
> > create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
> > Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
> > failed. The step failed.
> >
> > I can't find any documentation on 0x800401F3. Any ideas? Thanks!
>
>
>

[Database Administrator]

The error message I posted is the detailed message from the View History.
That's all there is, unless there is more detail somewhere else that I could
not find.

Thanks!

Jeff

"Ekrem Önsoy" wrote:

> There could be more detailed info if you right click on the Maintanence Plan
> and click View History? (I'm note sure if you got the error message you
> mentioned in your post from View History or not?)
>
> --
> Ekrem Önsoy

[Database Administrator]

Did you specify a Report file for the plan? If not, give it a try and check that file...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Jeff" wrote in message
news:45E493C1-ADC6-4392-8CD2-6EE0F34BD071@microsoft.com...
> The error message I posted is the detailed message from the View History.
> That's all there is, unless there is more detail somewhere else that I could
> not find.
>
> Thanks!
>
> Jeff
>
> "Ekrem Önsoy" wrote:
>
>> There could be more detailed info if you right click on the Maintanence Plan
>> and click View History? (I'm note sure if you got the error message you
>> mentioned in your post from View History or not?)
>>
>> --
>> Ekrem Önsoy
>

[Database Administrator]

I generated a new version of the plan with the wizard and set the logging,
but no log was created. I also tried the e-mail output. I thinkk it dies
before it gets that far. I added an output file in the Agent job, but it
just repeats the "Could not create DTS.Application because of error
0x800401F3".

"Tibor Karaszi" wrote:

> Did you specify a Report file for the plan? If not, give it a try and check that file...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>

[Database Administrator]

Jeff,

I observe that you are running 9.00.3042.00, which is the initial SQL
Server 2005 SP2. I know that this had some problems with Maintenance Plans,
but I cannot detail all of the exposures, though some are mentioned here:
http://support.microsoft.com/kb/933508

You probably want to be at least at Cumulative Update 1 of SP2
http://support.microsoft.com/kb/935356/ but there are quite a few
cumulative update packages that have follow CU1.

I have seen recommendations a few months ago by people I respect to go to
3186 (CU3) but not beyond.
http://support.microsoft.com/kb/939537. If you pursue this, be sure to
follow the link regarding a DTS side-effect at
http://support.microsoft.com/kb/919224/.

FYI, there will be an SP3 later this year, according to:
http://blogs.technet.com/dataplatfor...ming-soon.aspx

RLF

"Russell Fields" wrote in message
news:eMKMFMKpIHA.4912@TK2MSFTNGP03.phx.gbl...
> Jeff,
>
> Here are some discussions for you to check out. Hope that one helps
>
> http://p2p.wrox.com/topic.asp?TOPIC_ID=43327 Read the last post for this
> one.
> http://www.experts-exchange.com/Web_..._21769758.html
> http://forums.microsoft.com/MSDN/Sho...61588&SiteID=1
>
> RLF
>
> "Jeff" wrote in message
> newsFEB0C82-CA48-489B-BCFC-D6EC3D125FB7@microsoft.com...
>>I just upgraded to SQ-Server 2005 and decided to use a Maintenance Plan
>> instead of my home-grown utility to run Check Database commands. I used
>> the
>> wizard to create the plan and used the SQL Server Agent account, which
>> has
>> sysadmin rights for now. When the job runs, it dies with the error:
>>
>> Executed as user: mydomain\username. Microsoft (R) SQL Server Execute
>> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
>> Corp 1984-2005. All rights reserved. Started: 11:47:22 AM Could not
>> create DTS.Application because of error 0x800401F3 Started: 11:47:22 AM
>> Finished: 11:47:22 AM Elapsed: 0.046 seconds. The package execution
>> failed. The step failed.
>>
>> I can't find any documentation on 0x800401F3. Any ideas? Thanks!
>
>

[Database Administrator]

Thanks! This is very helpful. I will work through the updates and see if
that helps. In the mean time, I can go back to running DBCC commands directly.

Jeff

"Russell Fields" wrote:

> Jeff,
>
> I observe that you are running 9.00.3042.00, which is the initial SQL
> Server 2005 SP2. I know that this had some problems with Maintenance Plans,
> but I cannot detail all of the exposures, though some are mentioned here:
> http://support.microsoft.com/kb/933508
....

[database manage]

I think its better to consult the Microsoft People if u really using the original version of the SQL Server 2005.