Re: Unable to set SQL proxy for xp_cmdshell

Do you get the account SID back when you SELECT SUSER_SID('<your ad
domain>/<your proxy account>')? Can you login locally on the SQL box using
the proxy account?

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Bry" <fqies_bry@xxxxxxxxx> wrote in message
news:1142575692.017795.18830@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have checked the google group search and found a topic regarding
the setting Proxy account for SQL agent. The topic was logged last Dec.

2003. I have the same issue but this time, a changed with Domain might
be the cause. we moved from NT domain to AD. I am encountering 'No
mapping between account names and security IDS was done.' error, when i

tried to reset the proxy using the new domain account. I have tried to
delete the proxy using the DEL of xp_sqlagent_proxy_account but i
encountered the same error. I used GET and it returned the result
having the old
domain name and user name. I am wondering if the SQL is still looking
for the SID of the NT domain account. please someone attended this
topic asap. i need to resolve this ASAP.. =)



.

Relevant Pages

  • Re: xp_sqlagent_proxy_account
    ... >Make sure that the account running SQL Server and/or ... >> I can no longer update the proxy account. ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to set SQL proxy for xp_cmdshell
    ... When I select the SID of the proxy account, ... i can login to SQL box using the proxy account via terminal ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2005 - Snapshot agent wont start
    ... account, so I tried to change the Snapshot Agent to use this acct as well. ... get the proxy account info if it is running as LocalSystem. ... SQL Server Agent but I am guessing that you want to have integrated ...
    (microsoft.public.sqlserver.replication)
  • Re: Run Batch Files with SQL Server Agent
    ... if you have set up SQL Agent to use proxy account, ... > I am connected to SQL Server with 'sa' and I tried the ...
    (microsoft.public.sqlserver.server)
  • Re: Operating System Command (CmdExec) will not run from Job Agent
    ... I created a proxy account, from what I understand SQL Server should only need ... Having created a proxy account who is a memeber of the local admin group I ...
    (microsoft.public.sqlserver.dts)