RE: MSDE + Restricted Accounts

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 04/09/04

Next message: Kevin McDonnell [MSFT]: "RE: Connecting to a remote server"

Previous message: Kevin McDonnell [MSFT]: "RE: job security and permission required"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Thu, 08 Apr 2004 22:09:12 GMT

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/prodtechnol/sql/2000/maintain/sp3sec02.mspx

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Next message: Kevin McDonnell [MSFT]: "RE: Connecting to a remote server"

Previous message: Kevin McDonnell [MSFT]: "RE: job security and permission required"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: Loose File Association with Limited User Account with Office 2
... When I logon with limited user account, my entire word docs have WordPad ... icons and when I double click, it opens WordPad. ... permission to write to the necessary parts of the registry. ...
(microsoft.public.office.misc)
Setting registry permission for client user
... The Task Manager needs to be disabled dynamically. ... But the limited User doesn't have permission ... How to Set the permission in TD or how could the TaskManager can be ...
(microsoft.public.windowsxp.embedded)
Re: making a limited user accounts be able to write to the root directory of an hdd
... You did not mention what OS you are using so I will assume XP since in Vista ... c:\program files is off limits in a limited user account. ... the limited user account can write to most any directory in either, ... permission to the D:\ to the limited user account? ...
(microsoft.public.windowsxp.general)
Re: Soundblaster Audigy 2 unavailable to a "limited user" account
... I am assuming that this would not work, as the Limited User account would not ... have permission to modify system files. ... "Road Runner" wrote: ...
(microsoft.public.windowsxp.general)
allowing limited users to remove hardware
... Using simple file sharing and a limited user account is it possible to grant ... permission to a user to remove a USB connected device. ...
(microsoft.public.windowsxp.security_admin)