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

From: Yih-Yoon Lee (yihyoon.online_at_gmail.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 09:35:33 -0600

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: SBS 2003 server/SQLServer 2000 SP3a service fails to load loca
    ... The account is the local system account which is the first check box in the ... I am not on site today to read the exact error. ... The only error I get is an authentication process problem. ... >> attempted to reconnect and even restablished the SQLServer without any luck. ...
    (microsoft.public.sqlserver.server)
  • 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)
  • 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)
  • 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)