Re: Having bad time to run SQLServer/SQLAgent with domain user

From: Marlon Brown (marlon_brownj@hotmail.com)
Date: 02/17/03 

From: "Marlon Brown" <marlon_brownj@hotmail.com>
Date: Mon, 17 Feb 2003 00:22:18 -0800

You guys rule ! Thanks.
>-----Original Message-----
>You should use Enterprise Manager to change the
>SQL Agent service account as it will automatically
>grant the required OS privileges and ACL rights to
>files and the registry.
>
>--
>HTH
>
>Jasper Smith (SQL Server MVP)
>
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Marlon Brown" <marlon_brownj@hotmail.com> wrote in
message
>news:027b01c2d644$dbdba3c0$a601280a@phx.gbl...
>> I am trying to configure SQLServerAgent and MSSQLSERVER
>> services to run with a standard domain user account
(non
>> member of any type of administrator group), as
>> recommended per MS.
>>
>> I go to the service.msc on MYSQLSERVER and I input the
>> respective domain user account there - I attempt to
start
>> the services and I get error 1069. On Enterprise
Manager,
>> I already created the respective domain user account on
>> \Security.
>>
>> In the local policies in MYSQLSERVER, I grant rights to
>> that account logon locally, run as a service and act
as a
>> part of the OS; still can't start MSSQLSERVER logged on
>> as that account.
>>
>> What am I missing ?!
>
>
>.
>

Relevant Pages

  • Re: How can I grant user run cmdexec
    ... This can happen when the startup account for SQL Server ... could reset the service accounts through Enterprise Manager ... Change the SQL Server or SQL Server Agent Service ...
    (microsoft.public.sqlserver.security)
  • Re: sql problem
    ... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" ...
    (comp.databases.oracle.server)
  • RE: Error 22022 when running SQLservices under different accounts
    ... If you are using the SQL Enterprise Manager to change the service ... startup accounts to use a non-admin account, ... How to change the SQL Server or SQL Server Agent Service account without ... Microsoft SQL Support ...
    (microsoft.public.sqlserver.setup)