Re: Access is deinied to SysAdmin and Administrators

Hi
This local computer is a part of domain from where you defined abc\user ?


"light_wt" <lightwt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:41E1AB2B-23AB-4603-A2BB-B3A2781A6EB0@xxxxxxxxxxxxxxxx
i have a strange problem with sql server agent.

if a local user account is used to start the MSSQLSERVER, the agent can be
started fine.

once started, a domain user account, say abc\user can start that service
fine.

however, that domain user can't be set to start the service. the services
will have a window saying "Unable to open MSSQLSERVER for writing on Local
Computer Error5: Access is denied.
that domain user is part of the local Administrators. It is a user with
sysadmin role.

also, this domain user, while is part of the local Administrator, can't
even
delete a user account of local machine. Again, the error is Access is
denied.

what is needed to fix it? thanks.


.

Relevant Pages

  • RE: Fax Preview Button
    ... Please use Add User wizard to add a new user, ... Client Computers wizard to add a new computer account, ... Remove the new user account from Local Administrators group, ...
    (microsoft.public.windows.server.sbs)
  • Re: Preserving Win XP User Settings when joining a Win2000 Domain
    ... Navigate to the new profile. ... if your old user account was a member of the local Administrators ... Only domain administrators group members are automatically added to ...
    (microsoft.public.win2000.networking)
  • Re: Log on to: Windows XP Pro Domain Logon Question
    ... Which is the User Account name and AD DNS name. ... have your domain name and your local computer name. ... have multiple domain logon options here. ... I was told that there is a cache file somewhere on the local system that ...
    (microsoft.public.windows.server.active_directory)
  • Log On Locally Denied for Administrators Member
    ... Global group used to nest membership of Local Administrators group at the ... When the user account is a granted access via the global group membership ...
    (microsoft.public.windows.server.clustering)
  • Re: Settle a Administrators dispute
    ... Jorge Silva wrote: ... no such thing as a 'local administrators' group on a domain ... at the user account used to logon in Active Directory ...
    (microsoft.public.windows.server.active_directory)