Re: Can't Start Local Instance

Jens;

Thanks for the response. The service is not running. When I open the Service
Manager and click on Start I get an error message "The service did not start
due to a login failure." . When I click OK on that popup I get a notice of
"Error 1069"

I do know the password I set for SA but it never even asks for it.

Wayne

"Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:uouRF6MSFHA.1176@xxxxxxxxxxxxxxxxxxxxxxx
> I think you messed up two things:
>
> If you get a login failure message, saying tht the password is not right
the
> server did start up. Look at the service and check if it has the staus
> started or if the service didn´t come up. If it did´nt come up post the
> error message here.
>
> If you are not able to login due to a false password (and you can´t
remeber
> any sysadmin password) you can change the autentification mode from SQl
> login to Windows login via the registry key:
>
> Default instance:
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
>
> Named instance:
> HKLM\Software\Microsoft\Microsoft SQL Server\Instance
> Name\MSSQLServer\LoginMode
>
> to 2 for mixed-mode or 1 for integrated. (Integrated is the default setup
> for the SQL Server 2000 Data Engine.)
>
>
> As an local Administrator you are able to reset the password now.
>
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>
> "Wayne Wengert" <wayneDONTWANTSPAM@xxxxxxxxxxx> schrieb im Newsbeitrag
> news:%23AHxDuMSFHA.2348@xxxxxxxxxxxxxxxxxxxxxxx
> >I installed SQL Server 2000 on my local WinXP Pro box. During the install
I
> > assigned a password to the sa account.
> >
> > Now, I cannot start the server. When I try to start it I get a login
> > failure
> > message? How do I go about resolving this?
> >
> > TIA
> >
> > Wayne
> >
> >
>
>


.

Relevant Pages

  • Re: Error connecting through the web
    ... A just plain "Login failed" error message indicates a bad ... login audits in SQL Server to make sure you are getting the ...
    (microsoft.public.sqlserver.connect)
  • Re: Cant Start Local Instance
    ... Perhaps the Password for the service Account did expire ... > Manager and click on Start I get an error message "The service did not ... >> If you get a login failure message, saying tht the password is not right ... >>>I installed SQL Server 2000 on my local WinXP Pro box. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cant Start Local Instance
    ... > Manager and click on Start I get an error message "The service did not ... >> If you get a login failure message, saying tht the password is not right ... >> HTH, Jens Suessmeyer. ... >>>I installed SQL Server 2000 on my local WinXP Pro box. ...
    (microsoft.public.sqlserver.setup)
  • Re: why only sa can connect to SQL server 2005 instance?
    ... login failure. ... That will give you more specific reasons as ... to why the login failed. ... I can connect to it by using sa only via SQL server management studio. ...
    (microsoft.public.sqlserver.connect)
  • Re: Where did the connections come from?
    ... We run an IIS server on a separate machine. ... I think only knowing the IP address of the failed login wouldn't help ... login isn't logged in SQL Server 2000, ... know where those login failure connections came from? ...
    (microsoft.public.sqlserver.security)
Loading