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
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
What version of WIndows XP do you have?
ASKER
Media Centre Edition
Version 2002
Service Pack 2
Im pretty sure the operating system version is not the problem.
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
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
"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.
Maybe a SQL Server 2000?
If so you need to give a name to new instance when you installs it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.