December 27, 2024 at 2:21 am
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!
December 27, 2024 at 10:15 am
This was removed by the editor as SPAM
December 27, 2024 at 2:30 pm
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.
December 28, 2024 at 6:23 pm
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
December 29, 2024 at 4:04 pm
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?
January 6, 2025 at 7:39 am
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
January 6, 2025 at 3:23 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy