We are starting to use SQL Server 2005 and need to be able to execute commands using the xp_cmdShell stored procedure within SQL. The SQL Documentation states two contraditory statements, see the link below.
1 - "The windows process spawned by xp_cmdShell has the same security rights as the SQL Server service account"
2 - "When it is run as a user that is not a memeber of the sysAdmin fixed server role it will use the #xp_cmdShell_proxy_account
When I execute the following statement as a user which is not a member of the sysadmin role it still returns "SQLAdmin", which is the user that owns the SQL Server service process.
exec master..xp_cmdshell 'set username'
The credential has been setup to use another user's credential, however it does not seem to impersonate the proxy account credential?
Is there a way, or a setting i might have missed, to make SQL Server impersonate the proxy_account credential when executing commands?
Any help would be appreciated.