Re: Unable to start SQL Server

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 11/21/03 

Date: Thu, 20 Nov 2003 18:58:32 -0600

Although Enterprise Manager is normally the correct place to change SQL
Server service account info, this method cannot be used when the service
won't start due to a password problem. This is why I suggested the SCM
method in this case. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Don Tipton" <dtipton@tax.state.oh.us> wrote in message
news:299501c3af9c$6e9d08d0$a601280a@phx.gbl...
> You can also change the password in Enterprise manager by
> clicking on the instance and selecting properties then the
> security tab.  I like to discourage people from using the
> service control manager because if you change the account
> responsible for starting SQL in the service control
> manager the directory permissons are not correctly changed.
> >-----Original Message-----
> >It looks like you are running the MSSQLServer service
> under your login
> >account.  You can change the service password from the
> Service Control
> >Manager:
> >
> >1) right-click My Computer --> Manage --> Services and
> Applications -->
> >Services
> >
> >2) double-click the MSSQLServer service and change the
> password under
> >the Login tab.
> >
> >-- 
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >-----------------------
> >SQL FAQ links (courtesy  Neil Pike):
> >
> >http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> >http://www.sqlserverfaq.com
> >http://www.mssqlserver.com/faq
> >-----------------------
> >
> >"Derek" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:04f401c3ae42$d8498fc0$a101280a@phx.gbl...
> >> I have had SQL Server up and running for almost 3 months
> >> on my laptop for development.
> >>
> >> It has been running fine.
> >>
> >> I have been disconnected from the network (and domain)
> >> for a few weeks while working at another site.
> >>
> >> Upon returning to the network this morning I had to
> >> change my password.
> >>
> >> SQL Server did not start with OS like it is meant to.
> >> When I try to manually start SQL Server I get the
> >> following message.
> >>
> >> "The service did not start due to a logon failure."
> >>
> >> Followed by.
> >> "An error 1069 - (The service did not start due to a
> >> logon failure.) occurred while performing his service
> >> operation on the MSSQLServer service."
> >>
> >> Any suggestions about how to start it appreciated.
> >>
> >> Derek
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... - Have not modified Administrator account, but i ran the SQL script anyway. ... SQL account is not a local administrator. ... > has this server ever been upgrade from SQL Server 7.0 or is this SQL ...
    (microsoft.public.sqlserver.fulltext)
Loading