|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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 Show quoteHide quote "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" <madri***@discussions.microsoft.com> wrote in message Why does MS not reply to my problem?news:E31EB027-8D19-4F08-BA15-B97315C5BDD5@microsoft.com... on the homepage there is the information that a support person will reply within 2 business days! regards Show quoteHide quote "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! Show quoteHide quote "Anthony Thomas" <ALTho***@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" <madri***@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 > >  
Other interesting topics
sql data corruption
Format Files - Bcp Images and PDF's in the same DB or in another DB? how to resolve deadlock issues Problem with different version of SQL Server validate data of target database against source database structure..How? Application respond slowly Do I still need pagefile? Restore needs too much space Configuration |
|||||||||||||||||||||||
