Re: Unable to start SQL Server

From: Don Tipton (dtipton_at_tax.state.oh.us)
Date: 11/20/03 

Date: Thu, 20 Nov 2003 11:28:10 -0800

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 2005 Tools
    ... I have tried my best to warn the manager who authorized this sort of work. ... and I need to know how to use this thing to connect to the database remotely. ... I have already forwarded TCP port 1433 and UDP port 1434 to the SQL server ... a clumsy or inept developer (or ...
    (microsoft.public.sqlserver.connect)
  • Re: Hard Drive wont stop spinning
    ... Security Accounts Manager ... SQL Server ... Symantec Lic NetConnect service ... Windows Firewall/Internet Connection Sharing ...
    (microsoft.public.windowsxp.perform_maintain)
  • Hard Drive wont stop spinning
    ... Security Accounts Manager ... SQL Server ... Symantec Lic NetConnect service ... Windows Firewall/Internet Connection Sharing ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Locking in SQL Server
    ... > But I think main problem is, this is his first proj on SQL server and MS ... >> If your manager understand locking, he/she will understand why it isn't possible. ... >>>> Say User A issues the following command: ... >>>> In this case User B goes into Deadlock situation. ...
    (microsoft.public.sqlserver.programming)
  • Re: Problems with Off. Pro Accounting & SQL Server connecting remo
    ... SQL Server over the network, I just do not think it is really designed to ... There are a number of factors that can affect the MS Office Business Contact Manager (BCM), including whether or not you're using a ...
    (microsoft.public.office.setup)
Loading