Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ERROR CREATING PROXY ACCOUNT.... Expand / Collapse
Author
Message
Posted Monday, November 24, 2008 5:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 10, 2014 4:41 AM
Points: 77, Visits: 99
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_NAME USERNAME
Post #607451
Posted Wednesday, September 17, 2014 3:09 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 6:37 PM
Points: 35,353, Visits: 31,895
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1614633
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse