RE: xp_sqlagent_proxy_account and post sp2
From: Lan Lewis-Bevan [MS] (lanlb@online.microsoft.com)
Date: 09/26/02
- Next message: Andrew John: "Re: WITH ENCRYPTION en masse"
- Previous message: Steve: "Trace Files"
- In reply to: Brian Smith: "xp_sqlagent_proxy_account and post sp2"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: lanlb@online.microsoft.com (Lan Lewis-Bevan [MS]) Date: Thu, 26 Sep 2002 17:29:49 GMT
Have you tried to reset the account with a different UID?
Here is an example from SQL BOL:
EXEC master.dbo.xp_sqlagent_proxy_account N'SET',
N'NETDOMAIN', -- agent_domain_name
N'ralph', -- agent_username
N'RalphPwd', – agent password
If this does not work, will it return the same error?
Regards,
Lan Lewis-Bevan
SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
- Next message: Andrew John: "Re: WITH ENCRYPTION en masse"
- Previous message: Steve: "Trace Files"
- In reply to: Brian Smith: "xp_sqlagent_proxy_account and post sp2"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
