ERROR CREATING PROXY ACCOUNT....

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » ERROR CREATING PROXY ACCOUNT....

ERROR CREATING PROXY ACCOUNT....

Rate Topic

Display Mode

Topic Options

Author

Message

Jorge Mendes

Posted Monday, November 24, 2008 5:55 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 18, 2012 12:34 PM
Points: 76, Visits: 88

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

« Prev Topic | Next Topic »

Permissions