[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

the service didn't start due to a login failure

Posted on 2005-04-10
3
Medium Priority
?
562 Views
Last Modified: 2013-11-13
I have an sql server witch is installed on a computer1, I can logon to a computer1 with administrator account, but I can't start sql server services, which means i can't connect to it, it gives me error "the service didn't start due to a login failure"

I edited registred sql server properties and the "use windows authentication" radio button is selected.

Any idea?

thanks
0
Comment
Question by:Chuckbuchan
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
anthonywjones66 earned 1000 total points
ID: 13747918
The registered sql server properties only affect how enterprise manager attempts to connect to the sql service.

To see why SQL server won't start use the 'Services' admin tool.  Scroll to 'MSSQLSERVER' and edit it's properties.  Normally the logon is set to Local System account.  If the 'This account' is selected ensure a valid user name and password are entered.

Anthony.
0
 

Author Comment

by:Chuckbuchan
ID: 13747999
I was just there, and fixed it
Go to Services in Administrative tools.
2. Open MSSQLSERVER and click on the Log On type.
3. Enter your domain password.
0
 

Author Comment

by:Chuckbuchan
ID: 13748002
thank you though.....
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Progress

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question