Error 22042: xp_setsqlsecurity() raises error -2147024893

Hello MS-Support,
Please help with the following problem:
I want to change the service account under which sqlserver runs to another
local user with less privileges.
My problem is that the following error raises in Enterprise manager:
Error 22042: xp_setsqlsecurity() raises error -2147024893 'The system cannot
find the path specified'
regards
Why does MS not reply to my problem?
on the homepage there is the information that a support person will reply
within 2 business days!
regards
"madrianr" wrote:

> Hello MS-Support,
> Please help with the following problem:
> I want to change the service account under which sqlserver runs to another
> local user with less privileges.
> My problem is that the following error raises in Enterprise manager:
> Error 22042: xp_setsqlsecurity() raises error -2147024893 'The system cannot
> find the path specified'
> regards
|||Try this; it should help.
How to change the SQL Server or SQL Server Agent Service account without
using SQL Enterprise Manager in SQL Server 2000
http://support.microsoft.com/default...b;en-us;283811
Sincerely,
Anthony Thomas

"madrianr" <madrianr@.discussions.microsoft.com> wrote in message
news:E31EB027-8D19-4F08-BA15-B97315C5BDD5@.microsoft.com...
Why does MS not reply to my problem?
on the homepage there is the information that a support person will reply
within 2 business days!
regards
"madrianr" wrote:

> Hello MS-Support,
> Please help with the following problem:
> I want to change the service account under which sqlserver runs to another
> local user with less privileges.
> My problem is that the following error raises in Enterprise manager:
> Error 22042: xp_setsqlsecurity() raises error -2147024893 'The system
cannot
> find the path specified'
> regards
|||After contacting MS-Support I have the solution for that problem:
......
After looking into the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Setup
I found out that the SQLDATAROOT is "D:\Datenbank\mssql instead of
"D:\Datenbank".
I changed this value and now it is possible to switch the account with the
Enterprise Manager.
After that I have to give that account full access to the folder
"c:\protokoll" (where the logs are present)
to start the sqlserver service/agent.
Now it seems that all works ok!
"Anthony Thomas" <ALThomas@.kc.rr.com> schrieb im Newsbeitrag
news:OOzJO7kbFHA.2288@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Try this; it should help.
> How to change the SQL Server or SQL Server Agent Service account without
> using SQL Enterprise Manager in SQL Server 2000
> http://support.microsoft.com/default...b;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "madrianr" <madrianr@.discussions.microsoft.com> wrote in message
> news:E31EB027-8D19-4F08-BA15-B97315C5BDD5@.microsoft.com...
> Why does MS not reply to my problem?
> on the homepage there is the information that a support person will reply
> within 2 business days!
> regards
> "madrianr" wrote:
another
> cannot
>