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'
regardsWhy 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.aspx?scid=kb;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...
> 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.aspx?scid=kb;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
>