Hi,

I'm a member of a SQL DBA Windows group, which is an 'sa' on a specific
server in my company. I am also a domain admin, and therefore local admin on
this specific server.

When I open any one of a bunch of DTS packages (created by another user, who
is the dbo of all of the databases referenced in the package), I get a
permissions error. Specifically, I can open the package, double-click on a
transform data task (to get it's properties), and view the SOURCE details.
But when I click on the DESTINATION tab, I get the following error:

"Cannot open database requested in login 'my_database_name'. Login fails."

This is a simple transform data task moving data from one sql database to
another, both databases on the same server.

If I log in as the owner of the DTS package, then I can obviously view all
properties without any errors. Is there some permission or right that is
needed, that isnt automatically granted to 'sa'?

Thanks,
dave