For some reason I cannot get a job to run under a different account other
than the SQL Agent. What I have done is the following.
1)Created a credential called operations that has the domain\user format
with its password. The user used is the SA of the sql server.
2)I created a proxy that is linked to this credential. In this Proxy I have
set it up to run all subsystems. I have also linked two users to this proxy.
3)I changed the job owner to be a user that will use the proxy
4)I changed each job step to run as the proxy created.
When I run the job, the job instantly fails. I keep getting the following
error.
Executed as user: DOMAIN\user. The process could not be created for step 1
of job 0x34E60C35C09E184EA8FD2E9E223821E2 (reason: A required privilege is
not held by the client). The step failed.
At one time this worked great. I believe this broke because of an update
that was applied.
I have recreated the credential and the proxy several times and I cannot see
what I am doing wrong.
Can anyone help me.Hi Chris, please take a look at this tip on what to take care of when running
a SQL Server Agent job using a proxy account:
http://www.sqlcommunity.com/Default.aspx?id=97&tabid=77
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"Chris Lumnah" wrote:
> For some reason I cannot get a job to run under a different account other
> than the SQL Agent. What I have done is the following.
> 1)Created a credential called operations that has the domain\user format
> with its password. The user used is the SA of the sql server.
> 2)I created a proxy that is linked to this credential. In this Proxy I have
> set it up to run all subsystems. I have also linked two users to this proxy.
> 3)I changed the job owner to be a user that will use the proxy
> 4)I changed each job step to run as the proxy created.
> When I run the job, the job instantly fails. I keep getting the following
> error.
> Executed as user: DOMAIN\user. The process could not be created for step 1
> of job 0x34E60C35C09E184EA8FD2E9E223821E2 (reason: A required privilege is
> not held by the client). The step failed.
> At one time this worked great. I believe this broke because of an update
> that was applied.
> I have recreated the credential and the proxy several times and I cannot see
> what I am doing wrong.
> Can anyone help me.|||Thank you for the reply. I will try this out. Is this aimed at the SQL
Agent Service account or the proxy account? Should I apply it to both?
Thanks again.
"Saleem Hakani" wrote:
> Hi Chris, please take a look at this tip on what to take care of when running
> a SQL Server Agent job using a proxy account:
> http://www.sqlcommunity.com/Default.aspx?id=97&tabid=77
> --
> Thank you,
> Saleem Hakani
> HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
> SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
> Articles, SQL Clinic and a lot of SQL fun.
>
> "Chris Lumnah" wrote:
> > For some reason I cannot get a job to run under a different account other
> > than the SQL Agent. What I have done is the following.
> > 1)Created a credential called operations that has the domain\user format
> > with its password. The user used is the SA of the sql server.
> >
> > 2)I created a proxy that is linked to this credential. In this Proxy I have
> > set it up to run all subsystems. I have also linked two users to this proxy.
> >
> > 3)I changed the job owner to be a user that will use the proxy
> >
> > 4)I changed each job step to run as the proxy created.
> >
> > When I run the job, the job instantly fails. I keep getting the following
> > error.
> >
> > Executed as user: DOMAIN\user. The process could not be created for step 1
> > of job 0x34E60C35C09E184EA8FD2E9E223821E2 (reason: A required privilege is
> > not held by the client). The step failed.
> >
> > At one time this worked great. I believe this broke because of an update
> > that was applied.
> >
> > I have recreated the credential and the proxy several times and I cannot see
> > what I am doing wrong.
> >
> > Can anyone help me.|||That's correct Chris. It's for SQL Server Agent service but you can applyit
for both as well.
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"Chris Lumnah" wrote:
> Thank you for the reply. I will try this out. Is this aimed at the SQL
> Agent Service account or the proxy account? Should I apply it to both?
> Thanks again.
> "Saleem Hakani" wrote:
> > Hi Chris, please take a look at this tip on what to take care of when running
> > a SQL Server Agent job using a proxy account:
> > http://www.sqlcommunity.com/Default.aspx?id=97&tabid=77
> >
> > --
> > Thank you,
> > Saleem Hakani
> > HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
> > SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
> > Articles, SQL Clinic and a lot of SQL fun.
> >
> >
> >
> > "Chris Lumnah" wrote:
> >
> > > For some reason I cannot get a job to run under a different account other
> > > than the SQL Agent. What I have done is the following.
> > > 1)Created a credential called operations that has the domain\user format
> > > with its password. The user used is the SA of the sql server.
> > >
> > > 2)I created a proxy that is linked to this credential. In this Proxy I have
> > > set it up to run all subsystems. I have also linked two users to this proxy.
> > >
> > > 3)I changed the job owner to be a user that will use the proxy
> > >
> > > 4)I changed each job step to run as the proxy created.
> > >
> > > When I run the job, the job instantly fails. I keep getting the following
> > > error.
> > >
> > > Executed as user: DOMAIN\user. The process could not be created for step 1
> > > of job 0x34E60C35C09E184EA8FD2E9E223821E2 (reason: A required privilege is
> > > not held by the client). The step failed.
> > >
> > > At one time this worked great. I believe this broke because of an update
> > > that was applied.
> > >
> > > I have recreated the credential and the proxy several times and I cannot see
> > > what I am doing wrong.
> > >
> > > Can anyone help me.|||Saleem,
I have done what you suggested. However I still have the same problem. I
did all the items on that list, short of rebooting the server. Any other
ideas?
"Saleem Hakani" wrote:
> That's correct Chris. It's for SQL Server Agent service but you can applyit
> for both as well.
> --
> Thank you,
> Saleem Hakani
> HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
> SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
> Articles, SQL Clinic and a lot of SQL fun.
>
> "Chris Lumnah" wrote:
> > Thank you for the reply. I will try this out. Is this aimed at the SQL
> > Agent Service account or the proxy account? Should I apply it to both?
> >
> > Thanks again.
> >
> > "Saleem Hakani" wrote:
> >
> > > Hi Chris, please take a look at this tip on what to take care of when running
> > > a SQL Server Agent job using a proxy account:
> > > http://www.sqlcommunity.com/Default.aspx?id=97&tabid=77
> > >
> > > --
> > > Thank you,
> > > Saleem Hakani
> > > HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
> > > SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
> > > Articles, SQL Clinic and a lot of SQL fun.
> > >
> > >
> > >
> > > "Chris Lumnah" wrote:
> > >
> > > > For some reason I cannot get a job to run under a different account other
> > > > than the SQL Agent. What I have done is the following.
> > > > 1)Created a credential called operations that has the domain\user format
> > > > with its password. The user used is the SA of the sql server.
> > > >
> > > > 2)I created a proxy that is linked to this credential. In this Proxy I have
> > > > set it up to run all subsystems. I have also linked two users to this proxy.
> > > >
> > > > 3)I changed the job owner to be a user that will use the proxy
> > > >
> > > > 4)I changed each job step to run as the proxy created.
> > > >
> > > > When I run the job, the job instantly fails. I keep getting the following
> > > > error.
> > > >
> > > > Executed as user: DOMAIN\user. The process could not be created for step 1
> > > > of job 0x34E60C35C09E184EA8FD2E9E223821E2 (reason: A required privilege is
> > > > not held by the client). The step failed.
> > > >
> > > > At one time this worked great. I believe this broke because of an update
> > > > that was applied.
> > > >
> > > > I have recreated the credential and the proxy several times and I cannot see
> > > > what I am doing wrong.
> > > >
> > > > Can anyone help me.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment