November 24, 2008 at 5:55 am
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
September 17, 2014 at 3:09 pm
Hi Jorge,
Did you ever get an answer from anywhere for this problem? If so, how did you solve it? Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply