Setting up proxy accounts that are not sysadmin

[hedgracer]

Can I set up proxy accounts that are not sysadmin to run ssis packages? If so, what would be the steps to do that (or point me to a url which has the answer)? Thanks for all help in advance.

Dave

 

[mrdenny]

Yes you can setup proxy accounts which are not members of the sysadmin fixed server role.

Create a crediential for the windows login which the proxy is going to impersonate.
Then setup a proxy pointing to that credential.
Then give the accounts which need to be able to use the proxy rights to use the proxy.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com