RE: SQL Agent Proxy account
From: Rodrigo (Rodrigo_at_discussions.microsoft.com)
Date: 09/20/04
- Next message: Mike Epprecht (SQL MVP): "RE: Diff between SQL server and SQL server Personal edition"
- Previous message: alfred: "RE: long delete"
- Next in thread: Dan Guzman: "Re: SQL Agent Proxy account"
- Reply: Dan Guzman: "Re: SQL Agent Proxy account"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Sep 2004 07:39:08 -0700
I'm having the same problem and still cound't find a solution.
If anyone has an idea, it will be very appreciated
"Alex" wrote:
> 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: Mike Epprecht (SQL MVP): "RE: Diff between SQL server and SQL server Personal edition"
- Previous message: alfred: "RE: long delete"
- Next in thread: Dan Guzman: "Re: SQL Agent Proxy account"
- Reply: Dan Guzman: "Re: SQL Agent Proxy account"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
