I have written a report in the Crystal IDE that runs fine. It is using OLE DB to a SQL Server database. When I then try to run that report at runtime, outside of Crystal, I get an error 534 returned. I am using the CPRE32 API and I am using version 8.5.Try looking up the error number or error description on www.google.com or on Crystal's Website: http://support.businessobjects.com/search/advsearch.asp|||I have done both of those. There is quite a bit of good information out there. But none of it so far has helped me. I recently tried switching from using P2SOLEDB.DLL to P2SSQL.DLL just to see what would happen, but I still get 534...|||Have you verified database?I usually get error 534 when database verification is needed.|||I will post this info here in hopes that it will help others who search for this problem.
The solution to my 534 problem was to use the PESetNthTableLocation API call. I had to call Crystal support to get this information.
The problem was caused by my changing database names at runtime.
I wrote all my reports to report on database "A", so to Crystal, the database "location" was "A.dbo.tablename". Then, at runtime, if the user of my application was running the reports on database "B", I was calling PESetNthTableLogOnInfo and setting the database to "B". However, according to Crystal support, sometimes that is not enough. Sometimes you also have to change the database location. So, once I called PESetNthTableLocation (setting it to "B.dbo.tablename") in addition to PESetNthTableLogOnInfo, it worked fine...
Showing posts with label runs. Show all posts
Showing posts with label runs. Show all posts
Sunday, March 11, 2012
Friday, February 24, 2012
Error 2908 when calling sqlncli for install package on Vista
I'm trying to run an install on Vista (the install runs fine on every other
platform)
I have a Custom Action to run the sqlncli.msi install from within our
install.
If I try to run sqlncli.msi on its own then it run correctly.
I am running our install using the option "Run as administrator"
However when the sqlncli starts running I get an error 2908 which is
something about not being able to update the registry.
Any ideas what I need to do to get this install to work in Vista ?
Hi,
This is a Visual Studio Setup setup project issue. I noticed that you had
post the same issue in the community microsoft.public.platformsdk.msi.
Other support engineer there will assist you with this issue further.
Please post back under that post.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||This has nothing to do with Visual Studio (yes I know there are lots of hits
if you do a search for 2908)
This is on a CLEAN install of Vista and I'm trying to create a package for
my application which needs the sqlncli
"Charles Wang[MSFT]" <changliw@.online.microsoft.com> wrote in message
news:W3nxNPglHHA.3352@.TK2MSFTNGHUB02.phx.gbl...
> Hi,
> This is a Visual Studio Setup setup project issue. I noticed that you had
> post the same issue in the community microsoft.public.platformsdk.msi.
> Other support engineer there will assist you with this issue further.
> Please post back under that post.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ====
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== ====
>
|||Hi Michael,
Thanks for your response.
I noticed that if you separately run sqlncli.msi, it would succeed, but if
you run it from your setup program, it would fail. We think that it is a
Windows setup issue on Vista and my colleague Lina had started to assist
you on your post at the community microsoft.public.platformsdk.msi. Please
feel free to post back under that post and she would work with you for
further assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
platform)
I have a Custom Action to run the sqlncli.msi install from within our
install.
If I try to run sqlncli.msi on its own then it run correctly.
I am running our install using the option "Run as administrator"
However when the sqlncli starts running I get an error 2908 which is
something about not being able to update the registry.
Any ideas what I need to do to get this install to work in Vista ?
Hi,
This is a Visual Studio Setup setup project issue. I noticed that you had
post the same issue in the community microsoft.public.platformsdk.msi.
Other support engineer there will assist you with this issue further.
Please post back under that post.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||This has nothing to do with Visual Studio (yes I know there are lots of hits
if you do a search for 2908)
This is on a CLEAN install of Vista and I'm trying to create a package for
my application which needs the sqlncli
"Charles Wang[MSFT]" <changliw@.online.microsoft.com> wrote in message
news:W3nxNPglHHA.3352@.TK2MSFTNGHUB02.phx.gbl...
> Hi,
> This is a Visual Studio Setup setup project issue. I noticed that you had
> post the same issue in the community microsoft.public.platformsdk.msi.
> Other support engineer there will assist you with this issue further.
> Please post back under that post.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ====
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== ====
>
|||Hi Michael,
Thanks for your response.
I noticed that if you separately run sqlncli.msi, it would succeed, but if
you run it from your setup program, it would fail. We think that it is a
Windows setup issue on Vista and my colleague Lina had started to assist
you on your post at the community microsoft.public.platformsdk.msi. Please
feel free to post back under that post and she would work with you for
further assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
Error 2908 when calling sqlncli for install package on Vista
I'm trying to run an install on Vista (the install runs fine on every other
platform)
I have a Custom Action to run the sqlncli.msi install from within our
install.
If I try to run sqlncli.msi on its own then it run correctly.
I am running our install using the option "Run as administrator"
However when the sqlncli starts running I get an error 2908 which is
something about not being able to update the registry.
Any ideas what I need to do to get this install to work in Vista ?Hi,
This is a Visual Studio Setup setup project issue. I noticed that you had
post the same issue in the community microsoft.public.platformsdk.msi.
Other support engineer there will assist you with this issue further.
Please post back under that post.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||This has nothing to do with Visual Studio (yes I know there are lots of hits
if you do a search for 2908)
This is on a CLEAN install of Vista and I'm trying to create a package for
my application which needs the sqlncli
"Charles Wang[MSFT]" <changliw@.online.microsoft.com> wrote in message
news:W3nxNPglHHA.3352@.TK2MSFTNGHUB02.phx.gbl...
> Hi,
> This is a Visual Studio Setup setup project issue. I noticed that you had
> post the same issue in the community microsoft.public.platformsdk.msi.
> Other support engineer there will assist you with this issue further.
> Please post back under that post.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ========================================
==============
>|||Hi Michael,
Thanks for your response.
I noticed that if you separately run sqlncli.msi, it would succeed, but if
you run it from your setup program, it would fail. We think that it is a
Windows setup issue on Vista and my colleague Lina had started to assist
you on your post at the community microsoft.public.platformsdk.msi. Please
feel free to post back under that post and she would work with you for
further assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============
platform)
I have a Custom Action to run the sqlncli.msi install from within our
install.
If I try to run sqlncli.msi on its own then it run correctly.
I am running our install using the option "Run as administrator"
However when the sqlncli starts running I get an error 2908 which is
something about not being able to update the registry.
Any ideas what I need to do to get this install to work in Vista ?Hi,
This is a Visual Studio Setup setup project issue. I noticed that you had
post the same issue in the community microsoft.public.platformsdk.msi.
Other support engineer there will assist you with this issue further.
Please post back under that post.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||This has nothing to do with Visual Studio (yes I know there are lots of hits
if you do a search for 2908)
This is on a CLEAN install of Vista and I'm trying to create a package for
my application which needs the sqlncli
"Charles Wang[MSFT]" <changliw@.online.microsoft.com> wrote in message
news:W3nxNPglHHA.3352@.TK2MSFTNGHUB02.phx.gbl...
> Hi,
> This is a Visual Studio Setup setup project issue. I noticed that you had
> post the same issue in the community microsoft.public.platformsdk.msi.
> Other support engineer there will assist you with this issue further.
> Please post back under that post.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ========================================
==============
>|||Hi Michael,
Thanks for your response.
I noticed that if you separately run sqlncli.msi, it would succeed, but if
you run it from your setup program, it would fail. We think that it is a
Windows setup issue on Vista and my colleague Lina had started to assist
you on your post at the community microsoft.public.platformsdk.msi. Please
feel free to post back under that post and she would work with you for
further assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============
Sunday, February 19, 2012
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
>
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
>
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 cann
ot
> 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/defaul...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\MS
SQLServer\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/defaul...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:
>
another[vbcol=seagreen]
> cannot
>
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 cann
ot
> 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/defaul...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\MS
SQLServer\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/defaul...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:
>
another[vbcol=seagreen]
> cannot
>
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
>
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
>
Subscribe to:
Posts (Atom)