SQL 2005 Express SP4 failing during installation.

I have been trying to install SQL 2005 Express SP 4 on a 2008 SBS server but having getting the error message attached below, have anyone seen this?
download--1-.png
LVL 1
jdffAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe Y.Commented:
Can you provide the summary.txt and details.txt files from the installation log folder? It should be somewhere in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log if you're running the 64-bit edition or Program Files (x86) for 32-bit.

Also, why install 2005 on a 2008 server? Can you use 2008 instead?
arnoldCommented:
You seem to have a newer fluent that prevents the installation.  As Joe young pointed out, can you use SQL server 2008 express? Within DB options you can set the DB to be 2005/9.0 ...

Shirt if that, find the sql native fluent library  for SQL server 2005 and install it, this will lead to the installer validating the presence of the older SQL client library which is currently leading to the failure.
arnoldCommented:
Here is the link where you can download the feature pack that includes the SQL 2005 Clint library installer for 32/64 bit system.


https://www.microsoft.com/en-us/download/details.aspx?id=15748
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

jdffAuthor Commented:
Joe, under the Microsoft SQL server I only have the folder 80 and 90 not 100.
jdffAuthor Commented:
Can I uninstall SQL 2005 from this 2008 SBS server an re-install it. I'm not using SQL for anything as far as I know.
jdffAuthor Commented:
Arnold I just have to have some SQL installed here so I can install Veritas Backup-Exec, that's all.
arnoldCommented:
No, I think sharepoint is using sql .  Lets start from the begining, What are you trying to do? What is the reason you are attempting to install Sql 2005 express on your system?
jdffAuthor Commented:
Hi Arnold, thanks for the reply, I need SQL 2005 SP4 or later in order to install the backup software.
arnoldCommented:
Why the not use the later version SQL 2008?
I think the issue is that your system has a conflict when checking/installing the SQL server 2005 native client library before it can install the DB engine.
jdffAuthor Commented:
Please provide me the link to download, I will use that. Thank you.
arnoldCommented:
Here is a link to download 2008 r2 express with tools.

https://www.microsoft.com/en-us/download/details.aspx?id=23650
jdffAuthor Commented:
Now im getting the attached error mesage when trying to install the 2008, seems like it is looking for the installation files from an old version to uninstall but it can't find it.
Desctop-screenshot.png
Vitor MontalvãoMSSQL Senior EngineerCommented:
Go to Add/Remove programs and uninstall everything related do SQL Server. Then reboot the machine and install the SQL Server 2008.
arnoldCommented:
Before removing, double check what you have configured and running on the system.  At times removal leaves the situation in a worse shape than it is now.
When doing the install of the 2008 do not try to uninstall the former version, run the two side by side.
jdffAuthor Commented:
Here is the error I got after the 2008 SQL Express Installation.
New error
jdffAuthor Commented:
Another error, looks like it does not find the VSS Writer source files to uninstall during the 2008 install, perhaps if I try to install the VSS Writer again, it will fix the uninstall path issue, the first error message is related to this VSS Writer.
error
arnoldCommented:
Please advise what does the system do, what services are running on it.  It is fairly straight forward to tell you to go through appwiz.cpl/features/roles and remove SQL.  You might have a component services/software that relies on the sql if install or the component that is installed and which will break when uninstalled.

If you are certain that the existing sql instance if any, components if any are unnecessary, follow Vitor's suggestion to remove the sql 2005 related vss components, native client library, etc. and then try again installing 2008.
jdffAuthor Commented:
Arnold, what I'm saying is that SQL 2008 is trying to uninstall the native VSS Writer during the install, and the VSS Writer tries to find its source files to uninstall it properly, so I guess I have to fix the VSS Writer first and then try to re-install SQL 2008 Express. But for me to fix the native VSS Writer I may need to install it again so it can find the source files during the uninstall, do you have any idea where I can download the 2005 native VSS Writer?
arnoldCommented:
it is part of the SQL 2005 Express MSI.  You can extract it:
or locate it after you run the installer,....

An MS technet reference is in the link Social forum
can not paste.. the link ....
deals with running the exe with the switch /X:d:\where_you_want_it_extracted.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jdffAuthor Commented:
I got is to work with your suggestion Arnold and other instructions from the link below.

http://msdn.developer-works.com/article/12692800/Sql+Server+VSS+Writer
https://support.microsoft.com/en-us/kb/909967
jdffAuthor Commented:
It worked for me.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.