Re: Can't Start Local Instance
- From: "Wayne Wengert" <wayneDONTWANTSPAM@xxxxxxxxxxx>
- Date: Sun, 24 Apr 2005 13:00:42 -0600
Jens;
Thanks for that education
Wayne
"Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:ecLDUKOSFHA.164@xxxxxxxxxxxxxxxxxxxxxxx
> 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
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>
.
- 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
- Re: Can't Start Local Instance
- From: Jens Süßmeyer
- Can't Start Local Instance
- Prev by Date: Re: Database Backup
- Next by Date: Problem installing MS SQL Server 2000
- Previous by thread: Re: Can't Start Local Instance
- Next by thread: Database Backup
- Index(es):
Relevant Pages
|
