Proxy Account Problem - Solution found

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Proxy Account Problem - Solution found

Author

Topic

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-04-04 : 13:51:48

I am having trouble with setting up an agent proxy account. I renamed the server and I cannot delete or change the agent proxy account. The proxy account was a local account on the server, and the proxy account still shows with the name of the server before I changed it. I believe that the information about the proxy account may be in the registry, but I have been unable to find it.

When I try to change or delete it, I just get a message saying “No mapping between account names and security IDs was done.”

I have done a lot of Google searches on this, and other people have had the problem, but no one seems to have a solution.

The script below and results show what it happening:



select servername= @@servername
select version = @@version
go
print 'Show proxy account'
exec xp_sqlagent_proxy_account N'GET'
go
print 'Delete proxy account'
exec xp_sqlagent_proxy_account N'DEL'
go
print 'Set proxy account'
exec xp_sqlagent_proxy_account 
 N'SET',N'SQLSERVER55', N'PRX_SQLSERVER55', N'mysecretpassword'
go
print 'Show proxy account'
exec xp_sqlagent_proxy_account N'GET'

Results:


servername
--------------
SQLSERVER55


(1 row(s) affected)


version
--------------------------------------------------------------------------
Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)
	May  3 2005 23:18:38
	Copyright (c) 1988-2003 Microsoft Corporation
	Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

(1 row(s) affected)

Show proxy account
Domain            Username
----------------- -------------------
SQLSERVER55TEMP   PRX_SQLSERVER55

(1 row(s) affected)

Delete proxy account
No mapping between account names and security IDs was done.
Set proxy account
No mapping between account names and security IDs was done.
Show proxy account
Domain            Username
----------------- -------------------
SQLSERVER55TEMP   PRX_SQLSERVER55

(1 row(s) affected)

Solution:

Delete the following registry keys. You may have to grant yourself permission to these keys, even if you are an administrator.


HKEY_LOCAL_MACHINE\SECURITY\Policy\Secrets
	SQLSERVERAGENT_SQLAgentProxyDomain
	SQLSERVERAGENT_SQLAgentProxyPassword
	SQLSERVERAGENT_SQLAgentProxyUsername

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources