Re: Win XP Pro + SQL Server 2000 (evaluation) - logon problem

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/04/04 

Date: Sun, 4 Jul 2004 19:39:31 +0530

Hi,

Login to OS as administratior and do below steps:-

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.

Thanks
Hari
MCDBA

"McMac" <McMac@discussions.microsoft.com> wrote in message
news:CEF57954-885A-4715-AD0E-FAEEF57E4254@microsoft.com...
> Hi
> I have configuration as above. During startup of SQL server I get an error
1069: the service did not start due to a logon failure.
> The instalation process gone correctly. I logon to OS as administrator.
>
> Any helpful hints?
>
> Thanks in advance ;-)

Relevant Pages

  • Re: SQL Logon Problem
    ... It seems the password or user in SQL Server service startup account is ... > error message: The sevice did no start due to a log on failure. ...
    (microsoft.public.sqlserver.connect)
  • Re: The service did npt strat due to logon failure
    ... It seems the password or user in SQL Server service startup account is ...
    (microsoft.public.sqlserver.server)
  • Re: Unable to start SQL server 2000 after changing user password
    ... After changing the Service startup account password, ... Control Panel - Admin tools -- Services ... The SQL server 2000> refuses to start. ...
    (microsoft.public.sqlserver.server)
  • Re: Login Failed
    ... Try starting SQL Server from command prompt. ... If you reconstruct the PDC server, on recreating the user all the SID to ... > Are you using domain OS user as the service startup account for MSSQL ... recreate OS users to access SQL ...
    (microsoft.public.sqlserver.clients)
  • Re: Cannot change Agent startup account on NT
    ... stored procedure which makes SQL Server try to change the setting. ... But the service account that SQL Server is ... The current startup account has been converted to the new ... > When I attempt to enter the new account in Agent Service Startup Account, ...
    (microsoft.public.sqlserver.setup)