Prev: cannot change is_not_trusted = 1
Next: Move SQL Database
From: unimatter on 6 Sep 2007 16:13
When trying to change the SqlAgent service account using Enterprise
Manager (SQL server Win2K SP4), get the error: Error 22042:
xp_SetSQLSecurity() returned error - 2147024690, 'The handle is
invalid.'
I've seen various people report this problem on newsgroups over the
years, but no one ever came up with a solution, other than changing it
manually using the services applet and then having to go through the
tedious manual process of setting all the file and registry
permissions and various other things for the account.
This SQL instance is running on a Win2K3 SP2 BDC.
Any ideas?

 | 
Pages: 1
Prev: cannot change is_not_trusted = 1
Next: Move SQL Database