Error 87 from GetProxyAccount on line 604
I am trying to set up a regular SQL login which is NOT a
sysadmin with the ability to run xp_cmdshell. It's not
the best idea, but I have no choice. I granted it
execute permissions on the proc and used
xp_sqlagent_proxy_account to point to a login which is a
local admin on the server. Whenever I try to execute
xp_cmdshell under that account, I get the error :
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 87 from GetProxyAccount on line 604
A search of KB and a few of these newsgroups turned up
nothing. The version number of SQL Server is 08.00.0818
(sp3 + security update).
Did you specify a proxy account? (Do this in EM, right click Agent.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris Clements" <chrisclements@.msn.com> wrote in message
news:3a0201c4a636$c892df90$a501280a@.phx.gbl...
> Error 87 from GetProxyAccount on line 604
>
> I am trying to set up a regular SQL login which is NOT a
> sysadmin with the ability to run xp_cmdshell. It's not
> the best idea, but I have no choice. I granted it
> execute permissions on the proc and used
> xp_sqlagent_proxy_account to point to a login which is a
> local admin on the server. Whenever I try to execute
> xp_cmdshell under that account, I get the error :
> Msg 50001, Level 1, State 50001
> xpsql.cpp: Error 87 from GetProxyAccount on line 604
> A search of KB and a few of these newsgroups turned up
> nothing. The version number of SQL Server is 08.00.0818
> (sp3 + security update).
>
|||Yes, I did. I posted this under the security newsgroup
and got the pointer to uncheck the "Only users with
sysadmin" checkbox...duh. Once I did that, the error
message changed to :
xpsql.c: Error 1314 from CreateProcessAsUser on line 492
I found that one in the KB though and am working out the
details now. Thanks.
>--Original Message--
>Did you specify a proxy account? (Do this in EM, right
click Agent.)
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Chris Clements" <chrisclements@.msn.com> wrote in
message[vbcol=seagreen]
>news:3a0201c4a636$c892df90$a501280a@.phx.gbl...
a[vbcol=seagreen]
a[vbcol=seagreen]
08.00.0818
>
>.
>
|||Yes, you need to make certain that the service account for Agent has appropriate permissions. You
can search Books Online for below string to find it as well:
"level token"
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:0d1e01c4a647$bca734e0$a401280a@.phx.gbl...[vbcol=seagreen]
> Yes, I did. I posted this under the security newsgroup
> and got the pointer to uncheck the "Only users with
> sysadmin" checkbox...duh. Once I did that, the error
> message changed to :
> xpsql.c: Error 1314 from CreateProcessAsUser on line 492
> I found that one in the KB though and am working out the
> details now. Thanks.
>
> click Agent.)
> message
> a
> a
> 08.00.0818
Showing posts with label getproxyaccount. Show all posts
Showing posts with label getproxyaccount. Show all posts
Tuesday, March 27, 2012
Error 87 from GetProxyAccount on line 604
Error 87 from GetProxyAccount on line 604
I am trying to set up a regular SQL login which is NOT a
sysadmin with the ability to run xp_cmdshell. It's not
the best idea, but I have no choice. I granted it
execute permissions on the proc and used
xp_sqlagent_proxy_account to point to a login which is a
local admin on the server. Whenever I try to execute
xp_cmdshell under that account, I get the error :
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 87 from GetProxyAccount on line 604
A search of KB and a few of these newsgroups turned up
nothing. The version number of SQL Server is 08.00.0818
(sp3 + security update).Have you tried allowing execute rights for guest
permission for xp_cmdshell in the master db ?
Its a bit of a naughty one but will should work until you
get your users sorted out.
Peter
"I love deadlines. I like the whooshing sound they make as
they fly by."
Douglas Adams
>--Original Message--
>Error 87 from GetProxyAccount on line 604
>
>I am trying to set up a regular SQL login which is NOT a
>sysadmin with the ability to run xp_cmdshell. It's not
>the best idea, but I have no choice. I granted it
>execute permissions on the proc and used
>xp_sqlagent_proxy_account to point to a login which is a
>local admin on the server. Whenever I try to execute
>xp_cmdshell under that account, I get the error :
>Msg 50001, Level 1, State 50001
>xpsql.cpp: Error 87 from GetProxyAccount on line 604
>A search of KB and a few of these newsgroups turned up
>nothing. The version number of SQL Server is 08.00.0818
>(sp3 + security update).
>.
>|||Peter,
I gave it a shot and I still get the same error. Thanks
for the suggestion though.
Chris
>--Original Message--
>Have you tried allowing execute rights for guest
>permission for xp_cmdshell in the master db ?
>Its a bit of a naughty one but will should work until
you
>get your users sorted out.
>Peter
>"I love deadlines. I like the whooshing sound they make
as
>they fly by."
>Douglas Adams
>
>>--Original Message--
>>Error 87 from GetProxyAccount on line 604
>>
>>I am trying to set up a regular SQL login which is NOT
a
>>sysadmin with the ability to run xp_cmdshell. It's not
>>the best idea, but I have no choice. I granted it
>>execute permissions on the proc and used
>>xp_sqlagent_proxy_account to point to a login which is
a
>>local admin on the server. Whenever I try to execute
>>xp_cmdshell under that account, I get the error :
>>Msg 50001, Level 1, State 50001
>>xpsql.cpp: Error 87 from GetProxyAccount on line 604
>>A search of KB and a few of these newsgroups turned up
>>nothing. The version number of SQL Server is
08.00.0818
>>(sp3 + security update).
>>.
>.
>|||Did you specify a proxy account? (Do this in EM, right click Agent.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris Clements" <chrisclements@.msn.com> wrote in message
news:3a0201c4a636$c892df90$a501280a@.phx.gbl...
> Error 87 from GetProxyAccount on line 604
>
> I am trying to set up a regular SQL login which is NOT a
> sysadmin with the ability to run xp_cmdshell. It's not
> the best idea, but I have no choice. I granted it
> execute permissions on the proc and used
> xp_sqlagent_proxy_account to point to a login which is a
> local admin on the server. Whenever I try to execute
> xp_cmdshell under that account, I get the error :
> Msg 50001, Level 1, State 50001
> xpsql.cpp: Error 87 from GetProxyAccount on line 604
> A search of KB and a few of these newsgroups turned up
> nothing. The version number of SQL Server is 08.00.0818
> (sp3 + security update).
>|||Yes, I did. I posted this under the security newsgroup
and got the pointer to uncheck the "Only users with
sysadmin" checkbox...duh. Once I did that, the error
message changed to :
xpsql.c: Error 1314 from CreateProcessAsUser on line 492
I found that one in the KB though and am working out the
details now. Thanks.
>--Original Message--
>Did you specify a proxy account? (Do this in EM, right
click Agent.)
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Chris Clements" <chrisclements@.msn.com> wrote in
message
>news:3a0201c4a636$c892df90$a501280a@.phx.gbl...
>> Error 87 from GetProxyAccount on line 604
>>
>> I am trying to set up a regular SQL login which is NOT
a
>> sysadmin with the ability to run xp_cmdshell. It's not
>> the best idea, but I have no choice. I granted it
>> execute permissions on the proc and used
>> xp_sqlagent_proxy_account to point to a login which is
a
>> local admin on the server. Whenever I try to execute
>> xp_cmdshell under that account, I get the error :
>> Msg 50001, Level 1, State 50001
>> xpsql.cpp: Error 87 from GetProxyAccount on line 604
>> A search of KB and a few of these newsgroups turned up
>> nothing. The version number of SQL Server is
08.00.0818
>> (sp3 + security update).
>
>.
>|||Yes, you need to make certain that the service account for Agent has appropriate permissions. You
can search Books Online for below string to find it as well:
"level token"
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:0d1e01c4a647$bca734e0$a401280a@.phx.gbl...
> Yes, I did. I posted this under the security newsgroup
> and got the pointer to uncheck the "Only users with
> sysadmin" checkbox...duh. Once I did that, the error
> message changed to :
> xpsql.c: Error 1314 from CreateProcessAsUser on line 492
> I found that one in the KB though and am working out the
> details now. Thanks.
>
>>--Original Message--
>>Did you specify a proxy account? (Do this in EM, right
> click Agent.)
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"Chris Clements" <chrisclements@.msn.com> wrote in
> message
>>news:3a0201c4a636$c892df90$a501280a@.phx.gbl...
>> Error 87 from GetProxyAccount on line 604
>>
>> I am trying to set up a regular SQL login which is NOT
> a
>> sysadmin with the ability to run xp_cmdshell. It's not
>> the best idea, but I have no choice. I granted it
>> execute permissions on the proc and used
>> xp_sqlagent_proxy_account to point to a login which is
> a
>> local admin on the server. Whenever I try to execute
>> xp_cmdshell under that account, I get the error :
>> Msg 50001, Level 1, State 50001
>> xpsql.cpp: Error 87 from GetProxyAccount on line 604
>> A search of KB and a few of these newsgroups turned up
>> nothing. The version number of SQL Server is
> 08.00.0818
>> (sp3 + security update).
>>
>>.
I am trying to set up a regular SQL login which is NOT a
sysadmin with the ability to run xp_cmdshell. It's not
the best idea, but I have no choice. I granted it
execute permissions on the proc and used
xp_sqlagent_proxy_account to point to a login which is a
local admin on the server. Whenever I try to execute
xp_cmdshell under that account, I get the error :
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 87 from GetProxyAccount on line 604
A search of KB and a few of these newsgroups turned up
nothing. The version number of SQL Server is 08.00.0818
(sp3 + security update).Have you tried allowing execute rights for guest
permission for xp_cmdshell in the master db ?
Its a bit of a naughty one but will should work until you
get your users sorted out.
Peter
"I love deadlines. I like the whooshing sound they make as
they fly by."
Douglas Adams
>--Original Message--
>Error 87 from GetProxyAccount on line 604
>
>I am trying to set up a regular SQL login which is NOT a
>sysadmin with the ability to run xp_cmdshell. It's not
>the best idea, but I have no choice. I granted it
>execute permissions on the proc and used
>xp_sqlagent_proxy_account to point to a login which is a
>local admin on the server. Whenever I try to execute
>xp_cmdshell under that account, I get the error :
>Msg 50001, Level 1, State 50001
>xpsql.cpp: Error 87 from GetProxyAccount on line 604
>A search of KB and a few of these newsgroups turned up
>nothing. The version number of SQL Server is 08.00.0818
>(sp3 + security update).
>.
>|||Peter,
I gave it a shot and I still get the same error. Thanks
for the suggestion though.
Chris
>--Original Message--
>Have you tried allowing execute rights for guest
>permission for xp_cmdshell in the master db ?
>Its a bit of a naughty one but will should work until
you
>get your users sorted out.
>Peter
>"I love deadlines. I like the whooshing sound they make
as
>they fly by."
>Douglas Adams
>
>>--Original Message--
>>Error 87 from GetProxyAccount on line 604
>>
>>I am trying to set up a regular SQL login which is NOT
a
>>sysadmin with the ability to run xp_cmdshell. It's not
>>the best idea, but I have no choice. I granted it
>>execute permissions on the proc and used
>>xp_sqlagent_proxy_account to point to a login which is
a
>>local admin on the server. Whenever I try to execute
>>xp_cmdshell under that account, I get the error :
>>Msg 50001, Level 1, State 50001
>>xpsql.cpp: Error 87 from GetProxyAccount on line 604
>>A search of KB and a few of these newsgroups turned up
>>nothing. The version number of SQL Server is
08.00.0818
>>(sp3 + security update).
>>.
>.
>|||Did you specify a proxy account? (Do this in EM, right click Agent.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris Clements" <chrisclements@.msn.com> wrote in message
news:3a0201c4a636$c892df90$a501280a@.phx.gbl...
> Error 87 from GetProxyAccount on line 604
>
> I am trying to set up a regular SQL login which is NOT a
> sysadmin with the ability to run xp_cmdshell. It's not
> the best idea, but I have no choice. I granted it
> execute permissions on the proc and used
> xp_sqlagent_proxy_account to point to a login which is a
> local admin on the server. Whenever I try to execute
> xp_cmdshell under that account, I get the error :
> Msg 50001, Level 1, State 50001
> xpsql.cpp: Error 87 from GetProxyAccount on line 604
> A search of KB and a few of these newsgroups turned up
> nothing. The version number of SQL Server is 08.00.0818
> (sp3 + security update).
>|||Yes, I did. I posted this under the security newsgroup
and got the pointer to uncheck the "Only users with
sysadmin" checkbox...duh. Once I did that, the error
message changed to :
xpsql.c: Error 1314 from CreateProcessAsUser on line 492
I found that one in the KB though and am working out the
details now. Thanks.
>--Original Message--
>Did you specify a proxy account? (Do this in EM, right
click Agent.)
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Chris Clements" <chrisclements@.msn.com> wrote in
message
>news:3a0201c4a636$c892df90$a501280a@.phx.gbl...
>> Error 87 from GetProxyAccount on line 604
>>
>> I am trying to set up a regular SQL login which is NOT
a
>> sysadmin with the ability to run xp_cmdshell. It's not
>> the best idea, but I have no choice. I granted it
>> execute permissions on the proc and used
>> xp_sqlagent_proxy_account to point to a login which is
a
>> local admin on the server. Whenever I try to execute
>> xp_cmdshell under that account, I get the error :
>> Msg 50001, Level 1, State 50001
>> xpsql.cpp: Error 87 from GetProxyAccount on line 604
>> A search of KB and a few of these newsgroups turned up
>> nothing. The version number of SQL Server is
08.00.0818
>> (sp3 + security update).
>
>.
>|||Yes, you need to make certain that the service account for Agent has appropriate permissions. You
can search Books Online for below string to find it as well:
"level token"
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:0d1e01c4a647$bca734e0$a401280a@.phx.gbl...
> Yes, I did. I posted this under the security newsgroup
> and got the pointer to uncheck the "Only users with
> sysadmin" checkbox...duh. Once I did that, the error
> message changed to :
> xpsql.c: Error 1314 from CreateProcessAsUser on line 492
> I found that one in the KB though and am working out the
> details now. Thanks.
>
>>--Original Message--
>>Did you specify a proxy account? (Do this in EM, right
> click Agent.)
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"Chris Clements" <chrisclements@.msn.com> wrote in
> message
>>news:3a0201c4a636$c892df90$a501280a@.phx.gbl...
>> Error 87 from GetProxyAccount on line 604
>>
>> I am trying to set up a regular SQL login which is NOT
> a
>> sysadmin with the ability to run xp_cmdshell. It's not
>> the best idea, but I have no choice. I granted it
>> execute permissions on the proc and used
>> xp_sqlagent_proxy_account to point to a login which is
> a
>> local admin on the server. Whenever I try to execute
>> xp_cmdshell under that account, I get the error :
>> Msg 50001, Level 1, State 50001
>> xpsql.cpp: Error 87 from GetProxyAccount on line 604
>> A search of KB and a few of these newsgroups turned up
>> nothing. The version number of SQL Server is
> 08.00.0818
>> (sp3 + security update).
>>
>>.
Error 87 from GetProxyAccount
Dear Friends,
I got this error:
Xpsql.cpp : error 87 from GetProxyAccount on line 604.
I use Ms Access for programming and SQL 2000 standart
version.
Can anyone explain to me ?, I event don't use proxy server
in my network.
Thanks.It's not a Proxy Server issue. The proxy account is used
when a non-sysadmin executes a xp_cmdshell. It's also the
security context used when a job owned by a non-sysadmin is
run. It sounds like you may need to set up the proxy account
yet. Take a look in books online for the extended stored
procedure xp_sqlagent_proxy_account. The help article has
links to related topics on xp_cmdshell and SQL Server Agent
properties (used by jobs).
-Sue
On Wed, 8 Oct 2003 19:08:00 -0700, "kresna rudy kurniawan"
<kresnark@.yahoo.com> wrote:
>Dear Friends,
>I got this error:
>Xpsql.cpp : error 87 from GetProxyAccount on line 604.
>I use Ms Access for programming and SQL 2000 standart
>version.
>Can anyone explain to me ?, I event don't use proxy server
>in my network.
>Thanks.sql
I got this error:
Xpsql.cpp : error 87 from GetProxyAccount on line 604.
I use Ms Access for programming and SQL 2000 standart
version.
Can anyone explain to me ?, I event don't use proxy server
in my network.
Thanks.It's not a Proxy Server issue. The proxy account is used
when a non-sysadmin executes a xp_cmdshell. It's also the
security context used when a job owned by a non-sysadmin is
run. It sounds like you may need to set up the proxy account
yet. Take a look in books online for the extended stored
procedure xp_sqlagent_proxy_account. The help article has
links to related topics on xp_cmdshell and SQL Server Agent
properties (used by jobs).
-Sue
On Wed, 8 Oct 2003 19:08:00 -0700, "kresna rudy kurniawan"
<kresnark@.yahoo.com> wrote:
>Dear Friends,
>I got this error:
>Xpsql.cpp : error 87 from GetProxyAccount on line 604.
>I use Ms Access for programming and SQL 2000 standart
>version.
>Can anyone explain to me ?, I event don't use proxy server
>in my network.
>Thanks.sql
Subscribe to:
Posts (Atom)