SQL: Error = -2147221504 (80040000) Invalid OLEVERB structure



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
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

8 commenti:

Anonymous said...

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

Anonymous said...

What exactly did you do, to grant it access to that particular folder?

Thanks,

Zach

Vittorio Pavesi said...

Just add write permission to the user impersonated by the SQL Server Service

Anonymous said...

Finding this solution saved my life. working late, deadline tomorrow and I get this error. Thanks for the fix.

Anonymous said...

so gay

Anonymous said...

Which user is "impersonated" by SQL Server Agent Service?? For instance, do you grant "write" to NT AUTHORITY\​NetworkSer​vice?? Do you grant permission on the folder you were discussing above (i.e. C:\Program Files\Microsoft SQL Server\80\Tools)??? thanks

Vittorio Pavesi said...

yes to network service account

Anonymous said...

Restarting the Domain Controller helped for me in this issue.