Re: Can't Start Local Instance
- From: "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 24 Apr 2005 16:10:01 +0200
The service don´t need the sa password, look in the event log, what the
error is based on. Perhaps the Password for the service Account did expire
or changed. There are many reasons why the service isn´t able to start.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"Wayne Wengert" <wayneDONTWANTSPAM@xxxxxxxxxxx> schrieb im Newsbeitrag
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
>> >
>> >
>>
>>
>
>
.
- References:
- Can't Start Local Instance
- From: Wayne Wengert
- Re: Can't Start Local Instance
- From: Jens Süßmeyer
- Re: Can't Start Local Instance
- From: Wayne Wengert
- Can't Start Local Instance
- Prev by Date: Re: Can't Start Local Instance
- Next by Date: Re: Can't Start Local Instance
- Previous by thread: Re: Can't Start Local Instance
- Next by thread: Re: Can't Start Local Instance
- Index(es):
Relevant Pages
|
