Service Account access fails

From: Orion Culver (oculver@wellsfargo.com)
Date: 05/20/02 

From: "Orion Culver" <oculver@wellsfargo.com>
Date: Mon, 20 May 2002 12:35:21 -0700

After rebooting a windows 2000 server the SQL Server
service fails to start.
 
We switched the Services accounts from Local System to a
Service account on Ad-ent for the various services running
on this, still test server. When rebooted the services
for SQL Server will not start even though the OLAP service
started. Access is prevent to the Ad-Ent Service Account,
the SA account and my own Ad-Ent ID. Error occurs both
from Enterprise Manager and PCAnywhere to the server
services.
 
Error 5 - Access denied is reported from all attempts to
start the SQL Service.
 
Any assistance would be appreciated.

Relevant Pages

  • Re: Linked Servers - setspn - domain account
    ... First of all I wouldn't use setspn, I tend to use ADSI Edit ... This is for a server called SQLNLB02 in the domain DOMSQL.COM ... I'm editing as it's SQL Service account). ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • Re: SetSPN problem
    ... The SPN is on the service account object not the server ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • Re: Kerberos w/ SQL and WIN2000
    ... I'm new to LDAP in general, but where would the ADSI key be located? ... > Win2000 will default to using kerberos to connect to the server anyway ... > For my server called sqlnlb01 in domain domsql.com using a service account ... > Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2005 non-administrator Service Account
    ... I run an SQL Server 2005 with a service account that is not a member of the ... account from the administrators group, that's when the service won't start ...
    (microsoft.public.sqlserver.security)
  • Re: Service Account access fails
    ... permissions needed by the service account 'Setting up Windows Services ... > After rebooting a windows 2000 server the SQL Server ... Access is prevent to the Ad-Ent Service Account, ...
    (microsoft.public.sqlserver.security)