SQL Maintenance Plan runs successfully but files not backed up to folder

I have a SQL Server 2005 SP4 instance.  When creating maintenance plans to back up the user and system databases they run successfully in less than 5 seconds.  Of course the databases are not backed up but the jobs ran successfully as far as SQL is concerned.  If I backup the databases manually it works without issue.  I have uninstalled and reinstalled the SQL client tools and integration services on this server and still have the same issue.  Any ideas?  Please advise.
Gary HarperAsked:
Who is Participating?
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.

Aneesh RetnakaranDatabase AdministratorCommented:
Check the maintenance plan log and see what's in there
Using SSMS, double click on your Maintenance Plan in the Object Explorer. In the Object Explorer Details, click on the "Reporting and Loging" icon (close to the "Manage Connections" button). Go to that path, and find the log file
0
PadawanDBAOperational DBACommented:
Any errors or otherwise helpful info in the error log for the sql agent job associated with the maintenance plan?
0
Gary HarperAuthor Commented:
Checking the reporting and logging I do see the error message

"2013-09-20 11:07:10 - ! [382] Logon to server 'E2PBLD01' failed (ConnAttemptCachableOp)"

How is that possible even though I am connected?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Aneesh RetnakaranDatabase AdministratorCommented:
Check the connection settings on your maintenance plan.
0
PadawanDBAOperational DBACommented:
Can you post a snapshot of the connection that the SSIS package is using as well as check what service account IS and/or SQL Server Agent are running as? (when you open the maintenance plan, it will be in Manage Connections...)  If it's trying to access a remote machine and the integration services account is installed as a local system account that would present an issue and also check the effective permissions of the SQL Server Agent's service account if it's a local connection.
0
Gary HarperAuthor Commented:
When going back to check the maintenance plan I now get the message

"Microsoft SQL Server Management Studio is unable to load this document.  The LoadFromSQLServer method has encountered OLE DB error code 0x80004005"

I have reinstalled client tools and integration services.  Is it possible something is inherently wrong with the SQL installation?
0
Aneesh RetnakaranDatabase AdministratorCommented:
login as another windows user and try to load the plan
0
Gary HarperAuthor Commented:
It allows me to run it successfully.  However it only takes 2 seconds to run and checking the maintenance plan log I get the same error:

"2013-09-20 15:16:10 - ! [382] Logon to server 'E2PBLD01' failed (ConnAttemptCachableOp)"

Any ideas?
0
Aneesh RetnakaranDatabase AdministratorCommented:
Open the maintenance plan, make a new connection, manually enter login info and save it. then run it
0
Tony303Commented:
I would scrap the maintenance plan and build one from scratch again, it'll take you 2 mins.
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
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 2005

From novice to tech pro — start learning today.