Link to home
Start Free TrialLog in
Avatar of rangers99
rangers99

asked on

SQL Server 2005 Installation Failed

Im running Windows XP and cant get sql server express 2005 to install.

The installation fails at the "SQL Server Database Services" component. I get this message
"The SQL Server service failed to start...."   and

"Running action to shutdown instance (Run AS Normal User)
RANU instance Shutdown in progress: MSSQL$SQLEXPRESS"

Ive attached the lengthy setup log as well.  Anyone have any ideas?
SQLSetup0011-DOUGLAS-SQL.log
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

What version of WIndows XP do you have?
Avatar of rangers99
rangers99

ASKER

Media Centre Edition
Version 2002
Service Pack 2

Im pretty sure the operating system version is not the problem.
Looks like isn't OS version.
I know isn't the answer that you'll like to hear, but I think you need to reinstall Windows XP SP2 and recent hotfixes. Maybe SQL Server 2005 rewrited some Windows XP files.

Good luck
Do you (or did you) have some version of SQL installed previously? I noticed this line in the log
"Product: Microsoft SQL Server 2005 -- Error 28086. An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name."

Maybe this will help http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1964147&SiteID=17
Looks like you have another SQL Server installed in the machine.
Maybe a SQL Server 2000?
If so you need to give a name to new instance when you installs it.
ASKER CERTIFIED SOLUTION
Avatar of vijay4sql
vijay4sql

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Best solution I found was here:
http://support.microsoft.com/kb/954835  - see Alternate Workaround Steps

Basically, install SQL Server AND the latest SP on ANOTHER machine (preferably XP, I used XP mode on my own machine).  Then install SQL Server on YOUR machine.  When you get to the point where it fails to start the SQL service, copy the Sqlservr.exe and Sqlos.dll files from the BINN folder on the successful machine into your machine.  Then click Retry and the service should start.

This is the only thing that worked for me from dozens of other suggestions.