Re: The service did npt strat due to logon failure

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 11:26:48 +0530

Hi,

It seems the password or user in SQL Server service startup account is
having issues.

What to do:-

1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the service

Do the above steps for SQL Agent service as well.

Note:

ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server service startup which do
not chage password frequently or no password expiry is set.

Thanks
Hari
MCDBA

"Charlie" <yunli@xtra.co.nz> wrote in message
news:GUXpc.6209$XI4.220530@news.xtra.co.nz...
> He All
> I just installed a SQL server on my PC when I tried to start it
> the system showed me a error message
>
> The service did npt strat due to logon failure
>
> then another message
>
> An error 1069 (The service did npt strat due to logon failure) occured
while
> performing
> this service operation on the MSSQLServer service
>
> what is happen to my PC? How can i fix it? Many thanks
>
> Charlie
>
>
>

Relevant Pages

  • Re: Error message 1069
    ... It seems the password or user in SQL Server service startup account is ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Service wont start
    ... It seems some should have changed the password of your SQL Server service ... startup account. ... the SQL Server mean by Logon Failure and how to solve it? ...
    (microsoft.public.sqlserver.server)
  • Re: AWE Memory
    ... Server service is using Local System Account and has not been granted Lock ... AWE is still enabled? ... you say your SQL Server already consumes 5.1GB of RAM so AWE ...
    (microsoft.public.sqlserver.security)
  • Re: Backing up transaction logs gives poor performance.
    ... By the way, the SQL Server service and Agent service both use the local System account, so I don't think I could log on interactively using that. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Backing up transaction logs gives poor performance.
    ... By the way, the SQL Server service and Agent service both use the local System account, so I don't think I could log on interactively using that. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
Loading