I have Upgrades a Sql Server 2000 database to Sql Server 2005 I have a AD
Domin account that I use to run Sql Server and all the various services as
was used in Sql Server 2000. I have the Upgraded credential in which I had
created a proxy in the MSDB. My user is a SQL Login which has db_datareader
and SQlAgentUserRole as well as the databaseMailUserRole. The login is
DB_owner in one of my user databases. I migrated a job to the SSIS Package
saved and improted it into the SSIS Repositiory. When I execute it, it runs
successfully. When I schedule it, it fails. The exact reason is unkown.
However with some deduction I changed the credential to be my AD Domain
account then reexecuted the package even though the owner and connections
were made with the SQL login. Everything executed with Sucess. My question
is, how do I create a global proxy that can be executed through the job
scheduler for a select group of users be it A sql login they have access to
or as them selves via Group Membership.