February 10, 2008 at 8:57 pm
How to setup a proxy account in 2K5 where a person can execute a job when he is not owner of that?
My understanding:
1.Create a Windows Group. Add that person there
2.Create a credential in SQL Server. Add that Windows account there. (But what should I give as password?)
3.Create a proxy in Agent. Add MSDB’s Operator role to that account. Add the newly credential to that proxy
Is there something wrong in these steps? Please let me know as I need to do it on a Prod directly.
Thanks a lot…
February 10, 2008 at 9:37 pm
Hope this helps.
February 11, 2008 at 2:51 am
You might find http://www.codeplex.com/SQLServerFineBuild helpful. I published FineBuild to help provide a 1-click install and configuration of SQL Server 2005. It has a section in the Reference manual on creating both the xp_cmdshell and SQL Agent proxies.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply