blog community

Welcome to blog community Sign in | Join | Help
in Search

Frank Bakker

Frank Bakker talks about software development

SQL Server 2005 vs. Office Web Components

Last week I installed SQL Server 2005 Developer Edition on a development PC. This took almost as long as installing an Oracle server, which is not what I am used to when running a 'routine' SQL Server Setup.

The SQL 2005 installer starts off with a check for all the prerequisites, and all lights were green. I choose an allmost default install of the client tools and the SQL instance itself. When half way installing the required components I got a message that I had a previous version of the 'Office Web Components' (OWC) installed. I needed to remove this previous installation and restart the setup of SQL Server. Bummer.

Checking the 'Add / Remove programs' applet I found that there was indeed a OWC XP version installed, after choosing 'Remove' and clicking through the dialogs I was ready for a retry. Starting up de SQL server setup again choosing the same options as before, all lights green again and .... 'a previous version of OWC is found, please uninstall and redo all the stuff you did twice before ....grrrrr.

Once again I fired up the add / Remove programs and found that now OWC 2003 was installed. Again I uninstalled it, did a reboot for safety and restarted the SQL Server Setup. What do you know... again the same message.

For the third time (of the forth I forgot the actual count) I uninstalled OWC from the Add / Remove programs applet and immediately after removing it I reopened the Add / Remove programs and It was still there!! Even after another reboot, uninstall etc etc the Add remove programs still showed OWC 2003 installed.

As a last resort I located the OWC11.msi on the SQL Server 2005 CD and reinstalled it directly from there. After this I was able to to re-run the SQL Server setup with no problem.

Published Monday, February 19, 2007 9:11 PM by frankb

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Rod said:

Is there any known connecting issue using OWC to access a SQL Server 2005 database?

March 23, 2007 12:03 AM
 

Matthew said:

This helped me out when I had the same problem thanks a lot.

July 25, 2007 9:41 PM
 

Peter Adams said:

Thanks, this saved my day
August 7, 2007 7:27 PM
 

Ali said:

Worked for me too. Another way Microsoft have found of making people less productive. I wonder how much they cost the economy with people constantly searching for workarounds on the internet?
August 28, 2007 11:38 AM
 

mikep said:

If installing from a 2 CD set, I found the OWC11.msi on the second CD worked whereas the one on the first did not.
October 10, 2007 6:44 AM
 

Stephanie said:

This is great! Helped perfectly! For anyone who is wondering where that file is it is under any of the folders on the top level, then under tools\setup\. I got mine from sql server itanium\tools\setup\ and it worked great! Thanks!!!!!!!
October 11, 2007 4:35 PM
 

Ahmad said:

That was great. It worked for me. thanks
October 25, 2007 12:56 PM
 

Alenka said:

What would we do without blogs?! Thank you so much, this really helped save my day.
October 16, 2008 8:12 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit
Powered by Community Server, by Telligent Systems