Re: Can't Start Local Instance

Hi

This descibes the problem and resolution:
http://support.microsoft.com/default.aspx?scid=kb;en-us;282254

John

"Wayne Wengert" <wayneDONTWANTSPAM@xxxxxxxxxxx> wrote in message
news:%23t$BcaNSFHA.3444@xxxxxxxxxxxxxxxxxxxxxxx
> 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
    ... Manager and click on Start I get an error message "The service did not start ... > 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
    ... 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: connection failed
    ... Your server is probably set up to only allow Windows Authentication. ... Either change to use both windows and SQL Server or change the login you are ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I have a error message: ...
    (microsoft.public.sqlserver.dts)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)