permissions xp_cmdshell  
Author Message
ChristopherHemmings





PostPosted: Fri Apr 30 09:38:35 CDT 2004 Top

SQL Server >> permissions xp_cmdshell

Hi!!!

which permissions are necessary to execute xp_cmdshell?

----->without being SA

Error:
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 87 from GetProxyAccount on line 604


tanks!!!

SQL Server146  
 
 
Gregory





PostPosted: Fri Apr 30 09:38:35 CDT 2004 Top

SQL Server >> permissions xp_cmdshell You will need to set up a proxy account first using
"xp_sqlagent_proxy_account". Then you should get the permission associated
with the account you "set" up as your proxy account.
--

----------------------------------------------------------------------------
----------------------------------------------------------------------------
----

Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples


> Hi!!!
>
> which permissions are necessary to execute xp_cmdshell?
>
> ----->without being SA
>
> Error:
> Msg 50001, Level 1, State 50001
> xpsql.cpp: Error 87 from GetProxyAccount on line 604
>
>
> tanks!!!
>
>
>


 
 
chris





PostPosted: Fri Apr 30 10:20:14 CDT 2004 Top

SQL Server >> permissions xp_cmdshell Heres what Ive done in SQL 2000. RClick the SQL Agent/ props/ job system/
uncheck Only users with SA bla bla.../ fill in appropriate credentials. Most
imprtantly, DO NOT set permissions on xp_cmdshell itself.




> Hi!!!
>
> which permissions are necessary to execute xp_cmdshell?
>
> ----->without being SA
>
> Error:
> Msg 50001, Level 1, State 50001
> xpsql.cpp: Error 87 from GetProxyAccount on line 604
>
>
> tanks!!!
>
>
>