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

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 02/17/03 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Mon, 17 Feb 2003 07:29:37 -0000

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: ADMTv3 Questions
    ... the permission grant to a user account is grant by the SID ... If persmissions are assigned to built-in groups in the domain to be ... SIDs exist in the destination domain. ...
    (microsoft.public.windows.server.migration)
  • Re: *** HELP *** Problems Accessing Simple VB.NET Access Database
    ... you can grant Write permissions for the ASPNET account. ... permissions for an individual file or for directory hierarchies. ... I add an OleDBConnection called OleDBConnection1 to Form18b.aspx. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: The application requires more database privileges than you have currently been granted.
    ... Is it yet another name for 'user', 'account' and 'schema'? ... I'm doing everything in Enterprise Manager. ... Then you grant CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE ... TRIGGER and possibly CREATE PROCEDURE to this user account. ...
    (comp.databases.oracle.misc)
  • Re: more user account options?
    ... and these custom groups can be used to grant some ... installing applications that install for all users instead ... > If not is there any way to give a limited account user ...
    (microsoft.public.windowsxp.security_admin)
  • Re: What right allows full access?
    ... How to grant permission to the Users group on those areas where my non-admin ... > the Users group on those areas where your non-admin account ... > taking ownership as an admin _might_ be needed. ...
    (microsoft.public.windowsxp.security_admin)