SQL 2005 Express SP4 failing during installation.

jdff
jdff used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

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?
Distinguished Expert 2017

Commented:
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.
Distinguished Expert 2017

Commented:
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
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

Author

Commented:
Joe, under the Microsoft SQL server I only have the folder 80 and 90 not 100.

Author

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.

Author

Commented:
Arnold I just have to have some SQL installed here so I can install Veritas Backup-Exec, that's all.
Distinguished Expert 2017

Commented:
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?

Author

Commented:
Hi Arnold, thanks for the reply, I need SQL 2005 SP4 or later in order to install the backup software.
Distinguished Expert 2017

Commented:
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.

Author

Commented:
Please provide me the link to download, I will use that. Thank you.
Distinguished Expert 2017

Commented:
Here is a link to download 2008 r2 express with tools.

https://www.microsoft.com/en-us/download/details.aspx?id=23650

Author

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ãoIT Engineer
Distinguished Expert 2017

Commented:
Go to Add/Remove programs and uninstall everything related do SQL Server. Then reboot the machine and install the SQL Server 2008.
Distinguished Expert 2017

Commented:
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.

Author

Commented:
Here is the error I got after the 2008 SQL Express Installation.
New error

Author

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
Distinguished Expert 2017

Commented:
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.

Author

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?
Distinguished Expert 2017
Commented:
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.
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

Author

Commented:
It worked for me.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial