Re: SBS 2003 server/SQLServer 2000 SP3a service fails to load loca

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: northwindccohio (northwindccohio_at_discussions.microsoft.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 08:19:06 -0800

The account is the local system account which is the first check box in the
Service properties. I have tried the Administrator and Network Service
accounts also, without any change. All passwords expire after 242 days in the
GPO setting. I am not on site today to read the exact error. Sorry. It says
service "cannot start because of the account failing to authenticate" to the
best of my memory.

"Yih-Yoon Lee" wrote:

> Resetting the log doesn't change authentication. What is the account
> that SQL Server is running under? Does the account has a password
> expiration policy? What is the exact error that you are getting?
>
> Yih-Yoon Lee
> My blog http://www.mssql-tools.com/blog
> E-mail: yihyoon.online@gmail.com
> /* remove .online to send me e-mail */
>
> northwindccohio wrote:
> > Out of the blue this past week I have the local SQLServer on a SBS 2003 fails
> > to load locally. The only error I get is an authentication process problem.
> > The event viewer shows nothing else either. I have reset the log in at both
> > the SQLServer Enterprise application and on the service itself. I have
> > attempted to reconnect and even restablished the SQLServer without any luck.
> > Has anyone else run into this. The other connections of SQLServer for
> > SharePoint and Monitoring are functioning and starting without any problem.
>

Relevant Pages

  • RE: SQL Agent wont start
    ... Both SQLServer and SQLAgent are now run under the Local System ... Windows Admin account which was used to start these services. ... Interestingly, when a sysadmin account ...
    (microsoft.public.sqlserver.server)
  • Re: Intranet connect to SQLServer Under users account.
    ... >> I have set up the Web site so that it uses Windows Integrated security, ... >> On a test webpage I can output the user account being used: ... >> SQLServer using their account. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SBS 2003 server/SQLServer 2000 SP3a service fails to load locally
    ... Resetting the log doesn't change authentication. ... Does the account has a password ... The only error I get is an authentication process problem. ... > the SQLServer Enterprise application and on the service itself. ...
    (microsoft.public.sqlserver.server)
  • Re: Access to sql2005
    ... When you run the site in the debugger, it could run under your account, ... When you run it "for real" it runs under a local ASPNET ... connect to SqlServer using a specified sqlserver account. ...
    (microsoft.public.dotnet.framework.aspnet)
  • FIXED! xp_sendmail works from QA but not from DTS package
    ... >> Do you use the same account for running both your SQLServer service and your ... >> SQLAgent service? ... then try to set SQLserver to use the same account ...
    (microsoft.public.sqlserver.server)