ERROR CREATING PROXY ACCOUNT....

• Jorge Mendes

  SSC-Addicted

  Points: 498

  More actions

  November 24, 2008 at 5:55 am

  #73111

  Hello again,

  I´m having the following error when i try to re enable one proxy account (1.-). I detect this problem after i've got one other problem with one SQL Server Login try to access one share (2.-). However when i execute xp_sqlagent_proxy_account to get the account that is used for the proxy the command returns the username that i'm using to the proxy account (3.-)

  Note: I'm getting this problem in SQL 2000

  Hope u can help me.

  Thanks and regards,

  JMSM 😉

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

  1.-

  EXEC master.dbo.xp_sqlagent_proxy_account N'SET',

  N'domain_name', -- agent_domain_name

  N'username', -- agent_username

  N'***********************' -- agent password

  The system cannot find the path specified.

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

  2.-

  exec xp_cmdshell 'dir \\ip_address\fileshare'

  Msg 50001, Level 1, State 50001

  xp_cmdshell failed to execute because LogonUserW returns error 1326. please make sure the service account SQL Server running under has appropriate privilege. For more information, search Book Online for topic related to xp_sqlagent_proxy_account.

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

  3.-

  EXEC master.dbo.xp_sqlagent_proxy_account N'GET'

  DOMAIN_NAMEUSERNAME

• Jeff Moden

  SSC Guru

  Points: 1003851

  More actions

  September 17, 2014 at 3:09 pm

  #1746225

  Hi Jorge,

  Did you ever get an answer from anywhere for this problem? If so, how did you solve it? Thanks.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)