Re: Can't Start Local Instance
- From: "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 24 Apr 2005 17:30:38 +0200
changing the LogOn setting to "Local System
> Account"?
Thats ok unless your SQL Server will need Acces to your network or services
with a permission need.
Then
> it asked for a password for "sa" Which is the "login" name. For example,
> if
> I have the following settings:
You are asked for two things
-the service account to start SQL Server under (see above, which can be
local system, or a domain or local account)
-the SA password, which is used to login to SQL Server, not the service, the
DBMS. SA ist the local systemadministrator which is the "superuser" on SQL
Server system, unless you disabled SQL Server login.
> "guest" as the DefaultLogin? Is that correct?
All users which can be authenticated by SQL Server, can do something in a
database with the user guest.
"
guest User
A special username, guest, can be added to a database to allow anyone with a
valid SQL Server login to access the database. The guest username is a
member of the public role. After the guest user has been added to a
database, any individual with a valid SQL Server login[md]regardless of
security mode[md]can access the database as the guest user. A guest user
works as follows:
1.. SQL Server checks to see whether the login ID has a valid username or
alias assigned. If so, SQL Server grants the user access to the database as
the username or aliases. If not, go to step 2.
2.. SQL Server checks to see whether a guest username exists. If so, the
login ID is granted access to the database as guest. If the guest account
does not exist, SQL Server denies access to the database.
"
from http://www.developer.com/tech/article.php/721441.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"Wayne Wengert" <wayneDONTWANTSPAM@xxxxxxxxxxx> schrieb im Newsbeitrag
news:OwqmNDOSFHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks for the help guys. I actually got it running by going to Control
> Panel/Admin Tools/Services and changing the LogOn setting to "Local System
> Account"?
>
> I am confused regarding the login settings. When I installed the SQL
> Server
> on my WinXP box it asked for a User Name, password and a domain name. Then
> it asked for a password for "sa" Which is the "login" name. For example,
> if
> I have the following settings:
>
> User: Wayne
> PW: mypw
> Domain: myMachineName
>
> and then I have the same password set for the "sa" account, what is it
> using
> to login. I noticed that when I looked at the registry settings it had
> "guest" as the DefaultLogin? Is that correct?
>
> Wayne
> "John Bell" <jbellnewsposts@xxxxxxxxxxx> wrote in message
> news:eImp$uNSFHA.3444@xxxxxxxxxxxxxxxxxxxxxxx
>> 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
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>
.
- 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
- Re: Can't Start Local Instance
- From: Jens Süßmeyer
- Re: Can't Start Local Instance
- From: Wayne Wengert
- Re: Can't Start Local Instance
- From: John Bell
- 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: Database Backup
- Previous by thread: Re: Can't Start Local Instance
- Next by thread: Re: Can't Start Local Instance
- Index(es):
Relevant Pages
|
