Andy - also set the right for obtaining tokens/quota's - can't remember the
exact name off the top of my head.
> We are experiencing the same problem.
> I have a Domain Acct (SQLSvcAcct) which has local admin rights on the SQL
> Box (SQLBox).
> In addition, the acct SQLSvcAcct has domain Log On as a Service, Log on
> Locally rights, the password does not expire.
> When attempting to start the SQL Server w/ this acct I get the message "A
> Required Privilege is not held by the client" (thanks MS for being
> I have attempted to start the service up as the domain admin acct also and
> this also produced the same error. To test the client priviliges I started
> up the Spooler Service as this acct and it successfully started.
> So is this a problem w/ SQL or a problem w/ the domain rights?
> I'm out of ideas on this machine anyone who has experienced this problem,
> please reply!!! (thanks)
> > Dave - run as a service privilege.
> > > I created an account in NT to run the SQL Server Service with the
> > > attributes:
> > > no password
> > > password never expires
> > > cannot change password
> > > member of local administrators group on SQL Server
> > > right to log on as a server.
> > > Yet when I try to assign this as the startup service account, I get the
> > > message:
> > > "A required privilege is not held by the client"
> > > What do I need to do to create an NT account for the SQL Server service?
> > > I am running SS7/SP1 on NTWS 4.0/SP6a.
> > > Thanks
> > > Dave
> > Neil Pike MVP/MCSE. Protech Computing Ltd
> > (Please reply only to newsgroups)
> > SQL FAQ (428 entries) see
> > forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
> (sqlfaq.zip - L7
> > - SQL Public)
> > or www.ntfaq.com/sql.html
> > or www.sql-server.co.uk
> > or www.mssqlserver.com/faq
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (428 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)