February 16, 2010 at 9:21 pm
When I tried to create a Maintenance Backup via the Maintenance Wizard, I encounter the following error message:
An OLE DB Error 0x80004005 (Client Unable To Establish Connection) occurred while enumerating package. A SQL ststement was issued and failed
Can someone tell me how can I resolve this problem...many thanks
February 16, 2010 at 9:57 pm
Are you taking backup to network drive? If so does this machine has access to network folder?
EnjoY!
February 16, 2010 at 10:03 pm
yes, i am backing up to a network drive....
but when i just started to create a new backup schedule...it prompt with the error message after keying in the sa authentation
February 17, 2010 at 9:35 am
First, make sure your client tools have been upgraded to at least the same version level as the server you are accessing. If your client tools are SP2 or greater, make sure the server you are accessing is also SP2 or greater.
Second, what are you doing changing connection information for maintenance plans? You shouldn't touch the connection information, nor should you have to.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 17, 2010 at 10:26 am
For one, you should not be using the sys admin account for anything. Create another account for back ups. Also, you cannot place the backup files onto a network drive, if the service account that SQL is running under, is not a domain account. Because you must grant that account access to the drive location where you want the file to be placed.
Verify the service account that SQL is using. If not a domain account, create one and change all the services over to use that one. Then create another account that the backup process will use. Do not use the SQL sys admin account for anything.
Who is your SQL DBA? They should have know this.
Andrew SQLDBA
February 17, 2010 at 6:23 pm
i am not changing anything in the maintenance plan....just happens that the maintenance plan as schedule failed to run....and I am trying to recreate a new maintenance plan and the error message appear after I key-in the sa password
February 17, 2010 at 6:27 pm
I have already set it as domain account access with administrator right but still I can recreate the maintenance plan....
February 18, 2010 at 5:27 am
What I was talking about is this............
You need to use a domain account to run the SQL Service. You will not be able to connect to any file share using the local account for the SQL Service. That account should not be an admin level permission account, use the lowest possible permission. Give the domain account write permission to the directory where you want the backup file to be placed.
And then for the actual Job schedule. You should not use the Sys admin account for scheduling, or anything for that fact. Set up a SQL Account for that. Use that account for the job schedule, and use another SQL Account that actually performs the backup.
Keep things simple.
Andrew SQLDBA
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply