Re: Service Account access fails

From: Steve Thompson (stevethompson@nomail.please)
Date: 05/20/02 

From: "Steve Thompson" <stevethompson@nomail.please>
Date: Mon, 20 May 2002 15:51:26 -0400

If the OLAP service started, the 'log on as a service' right must be set.
Change the MSSQLSERVER service to run as Local System. Start the MSSQLSERVER
service, follow the steps listed in BOL 'Troubleshooting MSSQLServer or
SQLServerAgent Services User Accounts'. It could be a number of things,
including lack of permissions to the registry.

Steve
"Orion Culver" <oculver@wellsfargo.com> wrote in message
news:51ce01c20035$7ad45e40$19ef2ecf@tkmsftngxa01...
> 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: Running Analysis Server 2000 on seperate box
    ... changing the service account sorted things. ... with 2GB ram on Windows Server 2003. ... The server has both the database and Analysis Services ... >to use Local System which is fine for local databases, ...
    (microsoft.public.sqlserver.olap)
  • Re: SPN for SSL over common name
    ... you can't register those SPNs under the SQL Server's ... service account is the MSSQL SPN. ... That SPN should be registered under ... Lastly, since the SQL Server is not being used for delegation anywhere, ...
    (microsoft.public.inetserver.iis.security)
  • Re: In SSP Admin page Search Setting link fails with access denied
    ... First I modified the permissions of the SSP service account as you said. ... administratie and service accounts (Office SharePoint Server): ... How to change the passwords for service accounts in SharePoint Server ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Kerberos w/ SQL and WIN2000
    ... are not using Linked Servers then you don't need to set up an SPN AFAIK ... 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 ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Agent Proxy Account
    ... I forwarded to Server Admin. ... > rather the sql server service account cannot log in. ... > The reboot was unplanned (automatic install of OS patches/hot fixes, ...
    (microsoft.public.sqlserver.security)