blog community
Frank Bakker » SQL Server 2005 vs. Office Web Components
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.

Posted 19-02-2007 21:11 by frankb
Filed under:

Comments

Rod wrote re: SQL Server 2005 vs. Office Web Components
on 23-03-2007 0:03

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

Matthew wrote re: SQL Server 2005 vs. Office Web Components
on 25-07-2007 21:41

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

Peter Adams wrote re: SQL Server 2005 vs. Office Web Components
on 07-08-2007 19:27
Thanks, this saved my day
Ali wrote re: SQL Server 2005 vs. Office Web Components
on 28-08-2007 11:38
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?
mikep wrote re: SQL Server 2005 vs. Office Web Components
on 10-10-2007 6:44
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.
Stephanie wrote re: SQL Server 2005 vs. Office Web Components
on 11-10-2007 16:35
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!!!!!!!
Ahmad wrote re: SQL Server 2005 vs. Office Web Components
on 25-10-2007 12:56
That was great. It worked for me. thanks
Alenka wrote re: SQL Server 2005 vs. Office Web Components
on 16-10-2008 8:12
What would we do without blogs?! Thank you so much, this really helped save my day.
Oren wrote re: SQL Server 2005 vs. Office Web Components
on 24-02-2009 10:59
FINALLY! Manually installing the OWC did the trick for me too. Thanks a lot.
stan lewis wrote re: SQL Server 2005 vs. Office Web Components
on 02-07-2009 16:06

ACE piece of advice.

Ambo wrote re: SQL Server 2005 vs. Office Web Components
on 21-07-2009 18:48

Thanks a lot!

peezy wrote re: SQL Server 2005 vs. Office Web Components
on 18-08-2009 17:28

I agree!

Manually installing the OWC11 was a lot easier!!!

Thanks MikeP...

P.S.  As mentioned earlier, I would not be able to do my job w/out blogs....

Add a Comment

(required)  
(optional)
(required)  
Remember Me?
Enter code (required)
Powered by Community Server (Commercial Edition), by Telligent Systems