When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed
server role, xp_cmdshell will be executed under the security context in
which the SQL Server service is running. When the user is not a member of
the sysadmin group, xp_cmdshell will impersonate the SQL Server Agent proxy
account, which is specified using xp_sqlagent_proxy_account. If the proxy
account is not available, xp_cmdshell will fail. This is true only for NT
4.0 and Windows 2000. On Windows 9.x, there is no impersonation and
xp_cmdshell is always executed under the security context of the Windows 9.x
user who started SQL Server.
Check in Books OnLine for security issues on xp_cmdshell
Quote:> I am getting the error : 'Logon failure: unknown user name
> or bad password'
> This happen when I try to run the exec master..xp_cmdshell
> What is up with this? I have created the login on the
> target pc and then created the account in sql.