SQL Server 2005 service fails to start

  • Hello,

    I’ve been trying to install Ms SQL Server 2005 for over two weeks now, and I’ve finally gotten to the point where the prerequisites all seem to be in place. Unfortunately, every time I try to install SQL Server itself, I get the following message:

    “The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."”

    The installer then “rolls back” the install and I’m left with three uninstalled products in the Setup list: “SQL Server Database Services,” “Reporting Services,” and “Workstation Components, Books Online…”.

    Does anyone have any thoughts? I can’t check the SQL Server Books Online topics because they don’t install, either; and I can’t make sense of the log files without them.

    Thanks!

  • This was removed by the editor as SPAM

  • Why are you trying to install SQL Server 2005 when the lowest supported version is SQL Server 2016?

    What version of Windows are you trying to install SQL 2005 on? I think the highest versions to support SQL 2005 are Windows 7 and Windows Server 2008 R2.

     

    • Use an older operating systemd
    • I presume this is a case of DRP or alike, so it should only be used for a short time: make the service account member of window local administrators group

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Quick question, what operating system are you using?

    😎

    And out of curiosity, what is the purpose of this exercise? Are you working with FDA approved equipment or such with upgrade limitations?

     

  • You are going to have to do some troubleshooting.  What do your install logs say about the problem. If you don't know where to find the logs, check out the current sql install documentation, this will help you find them.

    If you have no logs in the standard place but it looks like you have some log details in your system or user /temp folder this normally means the main SQL installercould not run. The most common cause for this is that you do not have .net installed. You may need both .net 2 and .net 3 depending on your OS.

    Please let us know the OS and SQL version details, the pre-reqs you have already installed, and what the log files say about why SQL failed to start.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • As Ed points out, analysing the residual log files does help!

    😎

    You will find a script for log recovery and analysis in this article

    Bringing them back from the dead – SQLServerCentral

     

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply