<p>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:</p>

<p>“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."”</p>

<p>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…”.</p>

<p>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.</p>

<p>Thanks!</p>

[{'answer_id': 63052, 'author': 'DougN', 'author_id': 7442, 'author_profile': 'https://Stackoverflow.com/users/7442', 'pm_score': 0, 'selected': False, 'text': "<p>While that error message is on the screen (before the rollback begins) go to Control Panel -> Administrative Tools -> Services and see if the service is actually installed.  Also check what account it is using to run as.  If it's not using Local System, then double and triple check that the account it's using has rights to the program directory where MS SQL installed to.  </p>\n"}, {'answer_id': 63515, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 2, 'selected': False, 'text': '<p>It looks like not all of your prerequisites are really working as they should be.  Also, you\'ll want to make sure that you are installing from the console itself and not through any kind of remote session at all.  (I know, this is a pain in the a@@, but sometimes it makes a difference.)</p>\n\n<p>You can acess the SQL Server 2005 Books Online on the Web at: <a href="http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspx" rel="nofollow noreferrer"><a href="http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspx</a></a>. This documentation should help you decipher the logs.</p>\n\n<p>Bonus tidbit: Once you get that far, if you plan on installing SP2 without getting an installation that fails and rolls back, another little pearl of wisdom is described here:\n    <a href="http://blog.andreloker.de/post/2008/07/17/SQL-Server-hotfix-KB948109-fails-with-error-1920.aspx" rel="nofollow noreferrer"><a href="http://blog.andreloker.de/post/2008/07/17/SQL-Server-hotfix-KB948109-fails-with-error-1920.aspx" rel="nofollow noreferrer">http://blog.andreloker.de/post/2008/07/17/SQL-Server-hotfix-KB948109-fails-with-error-1920.aspx</a></a>. (My issue was that the "SQL Server VSS Writer" (Service) was not even installed.) Good luck!</p>\n'}, {'answer_id': 156963, 'author': 'Mephisztoe', 'author_id': 23369, 'author_profile': 'https://Stackoverflow.com/users/23369', 'pm_score': 0, 'selected': False, 'text': '<p>We had a similar problem recently withour running SQL 2005 servers (more specifically: The reporting services). The windows services didn\'t start anymore with no real error message whatsoever.</p>\n\n<p>I found out that this problem was related to some KB hotfixes that have been deployed lately. For some reason those hotfixes resulted in the services taking longer than usually for starting up.</p>\n\n<p>Since by default, there is a timeout that kills the service after 30 seconds when it was not able to go beyond the start methods, this was the reason why it simply terminated.</p>\n\n<p>Maybe this is what you are experiencing.</p>\n\n<p>Theres a work around described on Microsoft Connect (<a href="http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=357144" rel="nofollow noreferrer">link</a>). Although the hotfixes listed in this article didn\'t match the ones that have been deployed to our systems, the workaround worked for us.</p>\n'}, {'answer_id': 242245, 'author': 'CPU_BUSY', 'author_id': 27688, 'author_profile': 'https://Stackoverflow.com/users/27688', 'pm_score': 0, 'selected': False, 'text': "<p>I'd try just installing the tools and database services to start with. leave analysis, Rs etc and see if you get further. I do remeber having issues with failed installs so be sure to go into add/remove programs and remove all the pieces that the uninstaller is leaving behind</p>\n"}, {'answer_id': 243202, 'author': 'James Green', 'author_id': 31736, 'author_profile': 'https://Stackoverflow.com/users/31736', 'pm_score': 0, 'selected': False, 'text': '<p>I have seen something similar before when the account the SQL Server is set to run under does not have the required permission.</p>\n\n<p>Tangentially, once it is installed, a common mistake is to change the login credentials from Windows Services, not from SQL Server Configuration Manager.  Although they look the same, the SQL Server tool grants access to some registry keys that the Windows tool does not, which can cause a problem on service startup.</p>\n\n<p>You can run <a href="http://technet.microsoft.com/en-us/sysinternals/bb896652.aspx" rel="nofollow noreferrer">Sysinternals RegMon</a>/<a href="http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx" rel="nofollow noreferrer">Sysinternals ProcessMon</a> while the install is running, filtering by sqlsevr.exe and Failure messages to see if the account credentials are a problem.</p>\n\n<p>Hope this helps</p>\n'}, {'answer_id': 259692, 'author': 'Eric Sabine', 'author_id': 1493157, 'author_profile': 'https://Stackoverflow.com/users/1493157', 'pm_score': 0, 'selected': False, 'text': "<p>I agree with Greg that the log is the best place to start.  We've experienced something similar and the fix was to ensure that admins have full permissions to the registry location HKLM\\System\\CurrentControlSet\\Control\\WMI\\Security prior to starting the installation.  HTH.</p>\n"}, {'answer_id': 15960858, 'author': 'Tilesh Khatri', 'author_id': 2272474, 'author_profile': 'https://Stackoverflow.com/users/2272474', 'pm_score': 3, 'selected': False, 'text': '<p>I had similar problem while installing SQL Server 2005 on Windows 7 Professional and got error <code>SQL server failed to start</code>. I logged in as a Administrator (my user id is administrator) in windows.</p>\n\n<p>SOLUTION</p>\n\n<ol>\n<li><p>Go to services, from control panel -> Administrative Tools</p></li>\n<li><p>Click on properties of "SQL Server (MSSQLSERVER)" </p></li>\n<li><p>Go to Log On Tab, Select "This Account" </p></li>\n<li><p>Enter your windows login detail (administrator and password)</p></li>\n<li><p>Start the service manually, it should work fine..</p></li>\n</ol>\n\n<p>Hope this too helps..</p>\n'}, {'answer_id': 21436164, 'author': 'REHAN SHAIKH', 'author_id': 3249628, 'author_profile': 'https://Stackoverflow.com/users/3249628', 'pm_score': 1, 'selected': False, 'text': "<p><strong>solution for the microsoft  sql server 2005 failed to  start</strong></p>\n\n<ol>\n<li>Read carefully all the tabs  and icon name when you open it</li>\n<li>Don't be in a hurry  be cool and do this procedure</li>\n<li>Start your sql and proceed further when u get this error than start with this solution .  do not quit the installation<br>\nstart->control panel-->administrative tools-->services-->in services search for the         sql server (sql express) -->click on logon (tab)--> check local system account &amp; also check<br>\nservice to interact with desktop -->click on recovery tab -->first failure  choose restart the service  ;second failure -->   run the program --> apply ok</li>\n</ol>\n"}, {'answer_id': 26820043, 'author': 'ks_baba', 'author_id': 1577780, 'author_profile': 'https://Stackoverflow.com/users/1577780', 'pm_score': 1, 'selected': False, 'text': '<p>To solve this problem, you may need to repair your SQL Server 2005</p>\n\n<p>Simple steps can be </p>\n\n<ol>\n<li>Update/Install .Net 2.0 framework. Windows Installer 3.1 available online recommended</li>\n<li>Download the setup files from Microsoft website :\n<a href="http://www.microsoft.com/en-in/download/details.aspx?id=184" rel="nofollow">http://www.microsoft.com/en-in/download/details.aspx?id=184</a> </li>\n<li>Follow the steps mentioned below from the Symantec website: \n<a href="http://www.symantec.com/connect/articles/install-and-configure-sql-server-2005-express" rel="nofollow">http://www.symantec.com/connect/articles/install-and-configure-sql-server-2005-express</a></li>\n</ol>\n\n<p>Hope this helps!</p>\n'}]
['https://Stackoverflow.com/questions/62999', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/-1/']