I am using a brand new XP machine and a Vista Business machine (which is not clean and been in use for a year).
I perform a command line install of SQL Server 2005 that installs a named instance of sql server. This works on most machines with a problem but on a couple machines (mentioned above) everything is fine until the very end of the install and the installer attempts to start the named instance of sql server and it fails. The message says it was unable to start the service.
Looking in services.msc I can see the newly installed named instance but I cannot manually start it. it refers to BOL and how to manually start the service.
The installer cannot continue from this point and rolls back the installation.
I have removed all SQL related services and programs using Add/Remove Programs and have deleted everything from Program Files\SQL Server 2005 and tried the install again but to no avail.
On the vista machine I have done the same and also used the Windows Installer Cleanup tool from MS and this still fails also.
I am stuck and not sure what I can do next.
I would really appreciate your help / advice and look forward to your reply.
The text file is 2.7M and I had problems posting it here so I have put it on my website with the links below.
This is the error message I get during installation:
Screen dump of the error
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 text file is 2.7M and too large to post here but here (I kept getting errors back when I submitted this post).
Here's a link to it:
SQL Error Text File (2.7M)
or much smaller zipped (190k):
SQL Error zip file (190k)
- Edited by Belliez Thursday, April 30, 2009 4:01 PM
Incidentally, I just re-booted the clean machine (after an xp sp3 install) and I got this error message:
SQLDUMPER library failed initialization. Your Installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct this problem.
This may be because the sqlexpr.exe installer failed because it didnt start the service and I hit cancel to continue.
Try installing the latest service pack (SP3) from the following link after installing the SQL Server 2005 RTM:
Express Edition: http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang=en
Other Editions : http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
The feedback says it is fixed in the Service Pack 2 (3037).(https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=252784&wa=wsignin1.0)
Thank you for your reply. I have tried installing latest version of SQL Express 2005 SP3 but to no avail. I have also updated Windows XP to SP3 and also to no avail.
I performed a full uninstall of all SQL Server and related components via Add/Remove Program and using Windows Install Clean Up and performed the install and also failed.
However, I performed a different install this time using the latest SQL Server 2005 SP3, checked advanced setup and selected LOCAL SYSTEM (instead of Network Service) and the default instance of SQL Server DID install. I tried this again with a named instance and it proceeded past the Starting Services in the setup and installed fine.
This may be a clue why the installer cannot start the service if it is installed as a Network Service. I can say this XP machine is on a network but NOT part of a domain. However, the Vista machine IS on the domain!
Hope someone can give me a few clues why this installs as Local Service only?