Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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: Sunday, July 5, 2015 3:38 PM
Points: 77, Visits: 114
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,

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.

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.

EXEC master.dbo.xp_sqlagent_proxy_account N'GET'

Post #607451
Posted Wednesday, September 17, 2014 3:09 PM



Group: General Forum Members
Last Login: Yesterday @ 6:06 PM
Points: 39,667, Visits: 36,794
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

Favorite Quotes:
"Has anyone ever told you that a query you have written runs too fast?" - Dwain Camps - 6 Mar 2014

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

Add to briefcase

Permissions Expand / Collapse