I got the following error executing a scheduled DTS package that use a "Copy SQL Server Objects Task" task:
SQL: Error = -2147221504 (80040000) Invalid OLEVERB structure
The error was generated due to an access denied for the SQL Server Agent account into the path:
C:\Program Files\Microsoft SQL Server\80\Tools
I think Microsoft forgot to write it into its knowledge base article ID 283811
8 commenti:
Excellent! Fixed a problem with DTS scheduled job failing regularly.
I looked everywhere for the answer - there are plenty people looking for an answer on this one.
Thanks a million.
Arvid Carlander
What exactly did you do, to grant it access to that particular folder?
Thanks,
Zach
Just add write permission to the user impersonated by the SQL Server Service
Finding this solution saved my life. working late, deadline tomorrow and I get this error. Thanks for the fix.
so gay
Which user is "impersonated" by SQL Server Agent Service?? For instance, do you grant "write" to NT AUTHORITY\NetworkService?? Do you grant permission on the folder you were discussing above (i.e. C:\Program Files\Microsoft SQL Server\80\Tools)??? thanks
yes to network service account
Restarting the Domain Controller helped for me in this issue.
Post a Comment