?
Solved

SQL Server 2005 Setup fails because SQL Server Failed to Start

Posted on 2009-12-31
3
Medium Priority
?
423 Views
Last Modified: 2012-05-08
Hello Experts,

I am having trouble installing SQL Server 2005:

I am installing on a work group using the Local System Account. I have installed and uninstalled several SQL Server instances using this method on this machine.

Now when I try to install a new instance, the setup fails during the SQL Server Database Services section with the following message: " The SQL Server service failed to start"

The OS is Vista so I trued to explicitly "Run as Administrator" even thogh I am logged on as Administrator - no luck

I also completely uninstalled all SQL Server components and now nothing will install back (see above error msg)

Does anyone know what is going on here???

Thanks!
0
Comment
Question by:Saxitalis
3 Comments
 
LVL 18

Accepted Solution

by:
brejk earned 2000 total points
ID: 26152559
What's in the installation error log? There should be a reason why the installation failed. Also, I found a KB article describing the same error message: http://support.microsoft.com/kb/920114.
0
 

Expert Comment

by:ibrahimammari
ID: 26152805
Check the SQL Service in Services Section in Windows management , and check the Logon properties for this service.
0
 

Author Closing Comment

by:Saxitalis
ID: 31671530
Thanks,

The link you provided gave me a clue what to do. I installed using Network Service instead of Local System. I don't really understand why Local System stopped working when it always worked in the past but all is well now...

Thanks!
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Loops Section Overview
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

850 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