sql server 2008 maintenance plan

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?
johnnyg123Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chapmandewCommented:
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.
0
johnnyg123Author Commented:
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


0
chapmandewCommented:
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 SSIS...do you have SSIS installed?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnnyg123Author Commented:
Well......

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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.