Home Forums SQL Server 2017 SQL Server 2017 - Development Proxy account not working in stored procedure RE: Proxy account not working in stored procedure

  • May 3, 2018 at 7:18 am

    #1989073

    For the first error you posted before this, you still need to grant execute permissions on xp_cmdshell to the standard user. If you grant execute and do NOT have a proxy, they will get an error. 

    I have set up the credential ##xp_cmdshell_proxy_account## with my own network credentials (to test).  I was under the impression that when the standard SQL Server user tried to execute xp_cmdshell, that SQL Server would use the credentials stored in ##xp_cmdshell_proxy_account## to execute.  Is that not right?