Wednesday, March 21, 2012

MSDE + Restricted Accounts

I appologize if this is in the wrong place. I have MSDE 2000 installed on a
machine to be used only by the local user. It is using mixed-mode authentic
ation. The machine is running windows 2000. When I login as a Restricted Use
r that user can't start the
MQSQL Server service. An Error 5 (Access Denied) is reported. I read in the
KB before that MSDE and even accesss 2000 can not run on restricted user acc
ounts by design. I would just like a link to that KB article. I have searche
d all day for it and I can
't seem to find the right combination of keywords. Thanks so much. Most of t
he KB articles seem to be only for XP, .NET and Office 2003.The problem is that only local admins have permission to stop and start
services.
You should be able to configure the MSSQL service to start automatically,
using a limited user account.
But, as a limited user logging onto a machine, you won't have the ability
to stop and start services.
Here's a referenced to the startup account permissions.
http://www.microsoft.com/technet/pr...n/sp3sec02.mspx
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment