|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Unable buttom reset proxy account
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Unable buttom reset proxy account
|
|
| Javier Rosas 2002-11-03, 9:23 pm |
| I have a domain administrator aliases account to run SQL
services, but the problem is that buttoms are not enabled.
What's wrong?
>-----Original Message-----
>Hi, Javier!
>
>What account is your SQL Server running under? Your SQL
>Server account may not have the appropriate permission(s).
>Are you also resetting the proxy account as a sysadmin
>user?
>
>HTH.
>;o)
>Ricky Artigas
>
>>-----Original Message-----
>>Hi,
>>
>>I wanna to set that a non-sysadmin user can exec
>>xp_cmdshell command in SQL7 but I have not able the
>>buttom "reset proxy account" in SQL Server Agent
>>Properties (Job System Tab)
>>
>>Anybody help me? how can I able this option?
>>
>>Thanks in advance.
>>Javier Rosas
>>.
>>
>.
>
| |
| Sue Hoegemeier 2002-11-03, 11:23 pm |
| Make sure you have the server registered in Enterprise
Manager with a sysadmin account.
You also need to uncheck the option for "Only user with
Sysadmn privleges can execute CmdExec and ActiveScripting
job steps".
-Sue
On Sun, 3 Nov 2002 18:57:08 -0800, "Javier Rosas"
<jrosashe@accival.com.mx> wrote:
>I have a domain administrator aliases account to run SQL
>services, but the problem is that buttoms are not enabled.
>
>What's wrong?
>
>>-----Original Message-----
>>Hi, Javier!
>>
>>What account is your SQL Server running under? Your SQL
>>Server account may not have the appropriate permission(s).
>>Are you also resetting the proxy account as a sysadmin
>>user?
>>
>>HTH.
>>;o)
>>Ricky Artigas
>>
>>>-----Original Message-----
>>>Hi,
>>>
>>>I wanna to set that a non-sysadmin user can exec
>>>xp_cmdshell command in SQL7 but I have not able the
>>>buttom "reset proxy account" in SQL Server Agent
>>>Properties (Job System Tab)
>>>
>>>Anybody help me? how can I able this option?
>>>
>>>Thanks in advance.
>>>Javier Rosas
>>>.
>>>
>>.
>>
| |
| Javier Rosas 2002-11-07, 11:23 pm |
| I was able to reset proxy account with the buttoms, but
when I wanna to run a sentence, I get an error, example
When I run it with an standard user
DECLARE @result int
EXEC @result = xp_cmdshell 'dir *.exe'
IF (@result = 0)
PRINT 'Success'
ELSE
PRINT 'Failure'
I get the error
Msg 50001, Level 1, State 50001
xpsql.c: Error 1314 from CreateProcessAsUser on line 502
Thanks in advance,
Javier Rosas
>-----Original Message-----
>Make sure you have the server registered in Enterprise
>Manager with a sysadmin account.
>You also need to uncheck the option for "Only user with
>Sysadmn privleges can execute CmdExec and ActiveScripting
>job steps".
>
>-Sue
>
>On Sun, 3 Nov 2002 18:57:08 -0800, "Javier Rosas"
><jrosashe@accival.com.mx> wrote:
>
>>I have a domain administrator aliases account to run SQL
>>services, but the problem is that buttoms are not
enabled.
>>
>>What's wrong?
>>
>>>-----Original Message-----
>>>Hi, Javier!
>>>
>>>What account is your SQL Server running under? Your SQL
>>>Server account may not have the appropriate permission
(s). [colo
r=darkred]
>>>Are you also resetting the proxy account as a sysadmin
>>>user?
>>>
>>>HTH.
>>>;o)
>>>Ricky Artigas
>>>
>>>>-----Original Message-----
>>>>Hi,
>>>>
>>>>I wanna to set that a non-sysadmin user can exec
>>>>xp_cmdshell command in SQL7 but I have not able the
>>>>buttom "reset proxy account" in SQL Server Agent
>>>>Properties (Job System Tab)
>>>>
>>>>Anybody help me? how can I able this option?
>>>>
>>>>Thanks in advance.
>>>>Javier Rosas
>>>>.
>>>>
>>>.
>>>
>
>.
>[/color]
| |
| Sue Hoegemeier 2002-11-10, 10:23 pm |
| The permissions, rights for the SQL Server service account
are incorrect. Refer to the following article for more info:
PRB: Error 1314 Raised By xp_cmdshell When Executed as
Non-SA User
http://support.microsoft.com/?scid=kb;en-us;Q248391
-Sue
On Thu, 7 Nov 2002 20:44:40 -0800, "Javier Rosas"
<jrosashe@accival.com.mx> wrote:
>I was able to reset proxy account with the buttoms, but
>when I wanna to run a sentence, I get an error, example
>
>When I run it with an standard user
>
>DECLARE @result int
>EXEC @result = xp_cmdshell 'dir *.exe'
>IF (@result = 0)
> PRINT 'Success'
>ELSE
> PRINT 'Failure'
>
>I get the error
>Msg 50001, Level 1, State 50001
>xpsql.c: Error 1314 from CreateProcessAsUser on line 502
>
>Thanks in advance,
>Javier Rosas
>
>>-----Original Message-----
>>Make sure you have the server registered in Enterprise
>>Manager with a sysadmin account.
>>You also need to uncheck the option for "Only user with
>>Sysadmn privleges can execute CmdExec and ActiveScripting
>>job steps".
>>
>>-Sue
>>
>>On Sun, 3 Nov 2002 18:57:08 -0800, "Javier Rosas"
>><jrosashe@accival.com.mx> wrote:
>>
>>>I have a domain administrator aliases account to run SQL
>>>services, but the problem is that buttoms are not
>enabled.
>>>
>>>What's wrong?
>>>
>>>>-----Original Message-----
>>>>Hi, Javier!
>>>>
>>>>What account is your SQL Server running under? Your SQL
>>>>Server account may not have the appropriate permission
>(s).
>>>>Are you also resetting the proxy account as a sysadmin
>>>>user?
>>>>
>>>>HTH.
>>>>;o)
>>>>Ricky Artigas
>>>>
>>>>>-----Original Message-----
>>>>>Hi,
>>>>>
>>>>>I wanna to set that a non-sysadmin user can exec
>>>>>xp_cmdshell command in SQL7 but I have not able the
>>>>>buttom "reset proxy account" in SQL Server Agent
>>>>>Properties (Job System Tab)
>>>>>
>>>>>Anybody help me? how can I able this option?
>>>>>
>>>>>Thanks in advance.
>>>>>Javier Rosas
>>>>>.
>>>>>
>>>>.
>>>>
>>
>>.
>>
|
|
|
|
|