March 14, 2013 at 5:35 pm
Hello
I have a Transact-SQL job step that I want to run under a proxy however I cannot get it to work. I have created the credential then created the proxy to run under all subsytems however when I try and choose the proxy in the 'run as' drop down it does not appear. I am running sql server 2008 enterprise edition
March 15, 2013 at 1:35 am
You need to give permission to the Agent Job owner to use the Proxy.
EXEC msdb.dbo.sp_grant_login_to_proxy @proxy_name=N'domain\user', @login_name=N'domain\user'
GO
Or browse to Principals under the proxy in SQL Agent.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy