Re: Can't Start Local Instance
- From: "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 24 Apr 2005 15:07:04 +0200
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
>
>
.
- Follow-Ups:
- Re: Can't Start Local Instance
- From: Wayne Wengert
- Re: Can't Start Local Instance
- References:
- Can't Start Local Instance
- From: Wayne Wengert
- Can't Start Local Instance
- Prev by Date: Can't Start Local Instance
- Next by Date: Re: Can't Start Local Instance
- Previous by thread: Can't Start Local Instance
- Next by thread: Re: Can't Start Local Instance
- Index(es):
Relevant Pages
|
