SQL Agent Proxy account
From: Alex (alim_at_rogers.com)
Date: 06/24/04
- Next message: Kelly: "BlackIce message from SQL Server"
- Previous message: Geoff N. Hiten: "Re: Regarding Processor Usage.."
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 10:23:50 -0400
Hi,
When I use the following command to create SQL Agent Proxy account, I
receive this error:
EXEC master.dbo.xp_sqlagent_proxy_account N'SET',
N'MYSERVER',
N'sqlproxy',
N'password'
Error executing extended stored procedure: Specified user can not login
The server is Windows 2000 and SQL Server 2000 SP3a. I created a local user
on MYSERVER called sqlproxy with password as password and I can login to
this box using terminal services using this credentials with no problem. I
even tried it with my domain account but still the same problem exists.
Where is the problem?
Thanks
- Next message: Kelly: "BlackIce message from SQL Server"
- Previous message: Geoff N. Hiten: "Re: Regarding Processor Usage.."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
