unable to create maintenance plan

Hot Topic

Another Mysterious issue in SQL 2005 & SSIS
capture delta
How do I programatically fail my custom destination component?
reading data row by row using openxml
Child packages: Execute them all out of process?
string literal problem
confident of data mining
UTC to GMT+3
xmlDocument - openxml
Matrix grouped by Day Part and Date

SQL Server

Conversion fails. Please analyze error msg.
Date Select Query - select between two dates
change Parameter order
2006-09-13 15:24:18.07 Logon Error: 18456, Severity: 14, State: 16.
Returning "ALL" records in a query
Group Update of Prices
How to create Vertical Partioning
Full Text Researching
Login failed for user 'username'. The user is not associated with a trusted SQL Server connection
Maxis 3G connection

unable to create maintenance plan

I get an Ole db error while trying to create maintenance plans:

An ole db error ox80004005( unable to create client connection)occurred while enumerating packeges.

If I make the the sql startup account a local admin, everything works fine. I have checked to see according to the kb article to see that the account has all the necessary windows permissions and the account does have all the necessary rights.

Thanks in advance for the help

KRSE




Answer this question

unable to create maintenance plan

  • lknm

    Have you tried creating that MP using another client's machine, I guess it could be a client tools problem/

  • Elfshadow14

    Have you installed SP2

    If not also note the post above "Maintenance Plan Changes in SQL Server 2005 SP2 "



  • Michal Golawski

    Make sure that you change the startup account via SQL Configuration Manager. When you do it that way it takes care of assigning correct permissions to that account.

  • Stalwart team member

    I am not sure, since sp2 has some issues with maintenance plans.

    Thanks

    KR



  • Jason D. Camp

    No, Just sp1 so far.

  • Snyper_Vash

    IT is happening on three different machines - this is while the client is trying to access the server on the same machine.

    Thanks

    KR



  • SelArom

    KRSE wrote:
    No, Just sp1 so far.

    Do you have any plans to install SP2 to see if that resolves your issue

    Paul A. Mestemaker II
    Program Manager
    Microsoft SQL Server Manageability
    http://blogs.msdn.com/sqlrem/



  • unable to create maintenance plan
Answer this question