Re: Can't Start Local Instance

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
> >> >
> >> >
> >>
> >>
> >
> >
>
>


.

Relevant Pages

  • Re: Security for Visual Studio.Net
    ... Point taken about using a less privileged account for SQL Server access. ... > I assume you have your connection strings mixed up in this post, ... > Windows login failure), and the second connection string is attempting to ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Security for Visual Studio.Net
    ... Point taken about using a less privileged account for SQL Server access. ... > I assume you have your connection strings mixed up in this post, ... > Windows login failure), and the second connection string is attempting to ...
    (microsoft.public.sqlserver.security)
  • SOLUTION: Problem connecting to sql server
    ... it is an account problem. ... Not associated with a trusted SQL Server ... go to Client Configuation properties on the client machine ... >> settings on the SQL server, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cant Start Local Instance
    ... Thats ok unless your SQL Server will need Acces to your network or services ... -the service account to start SQL Server under (see above, ... > "guest" as the DefaultLogin? ... > I am confused regarding the login settings. ...
    (microsoft.public.sqlserver.setup)
  • To obtain Web Service security context
    ... I'd like to to impersonate the domain account a web service runs under. ... So if I do a trusted connection to SQL Server it would be ... I like the approach with no global impersonation setting and manual ... change the current global settings because the project is not mine and far ...
    (microsoft.public.dotnet.framework.aspnet.security)