Rights to start/stop a service
- From: wawork@xxxxxxxxxxx (Randy K)
- Date: Thu, 01 Sep 2005 22:01:12 GMT
We have installed MSDE on 6 work PCs for use in a modeling project.
Since I have admin rights through the domain I did the install.
However, since the MSDE service runs as local system account and the
user who is logging in has no special rights the service won't start.
As a fix I went back and set the service to run as myself
DOMAIN\wawork which at first seemed worked. I would log out and the
modeling user would log in. The first time the SQL Server service
starts up fine. Then when he reboots the PC the next day it will no
longer startup. Not for that user or for me when I log back in as
myself. If I change it back to log on as local system account,
start/stop it, then set it to run as me DOMAIN\wawork it starts
working again. Why I don't know
When it stops working the error is:
The service did not start due to a logon failure.
or
Could not start the MSSQLSERVER service on local computer Error 5:
Access is denied.
So I'm hoping if the user who needs to run the models can be given
access to start/stop services we can leave MSDE set to run as local
system account. Does anyone know what rights need to be set to make
this happen? Our windows administrator can't find a place to give
users that right.
Thanks,
wawork@xxxxxxxxxxx
.
- Prev by Date: Error with MSDE with Crystal Report - From VB
- Next by Date: Access and MSDE
- Previous by thread: Error with MSDE with Crystal Report - From VB
- Next by thread: Access and MSDE
- Index(es):
Relevant Pages
|
