sql server 2008 maintenance plan

Posted on 2008-11-13
Last Modified: 2012-05-05
I have a clustered environment with a shared drive that sql server 2008 is installed on

I am trying to create a maintenace plan but it keeps failing with a login failed entry in the log file

I'm confused since the id is in format domain/administrator and this id password lets me log in to sql server 2008

any ideas?
Question by:johnnyg123
    LVL 60

    Expert Comment

    It is probably the user that is running the sql agent account.  Check that service and if necessary change it to an account that can log into the db.

    Author Comment

    I think I'm following you...let's see

    checked the sql server agent and the id dmz\administrator is running the sql agent account

    when I login in to sql server management studio I'm using dmz\administrator (with authentication set to windows authentication)

    That seems to work fine

    The maintenance plan is using local server connection which uses dmz\administrator (with authentication set to windows authentication)   but the maintenace plan is failing

    LVL 60

    Accepted Solution

    the maintenance plan is a job, so you can look under the jobs folder to get the history and detailed information regarding the problem.  The job should be using you have SSIS installed?

    Author Comment


    Funny you should mention SSIS

    When I looked in the job history, SSIS apparently was not installed.  

    Apparenlty some issues with ssis and clustering...will go down that road.  Thanks for the point in the right direction

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now