Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Cant install Workstation Com (ADD_LOCAL error)

Author  Topic 

tweaks_sav
Starting Member

2 Posts

Posted - 2008-02-27 : 17:32:34
Cannot install Workstation Components (Management Studio,etc) (ADD_LOCAL error)

I have Vista Ultimate (IIS Enabled), SQL Server 2005 Developer Edition
(downloaded and ran the SP2 Update), Visual Studio 2008. VS2008
installs no problem. When I install SQL Server 2005, I get an error
when it trys to install the last part( Workstation Components,
Management Studio, etc).
I have tried FULLY, MANUALLY removing all SQL products and registry
entries. I have used Windows Installer Cleanup Utility. I have tried
Microsoft's recommended way of manually removing SQL Server 2005.
If I manually run SqlRun_Tools.msi the error comes up right away.

The error is:
"A component that you have specified in the ADD_LOCAL property is
already
installed. To upgrade the existing component, refer to the
template.ini and
set the UPGRADE property to the name of the component."

Here's the Setup Error log: http://toby.pastebin.com/f63405e24

Any help?! Thanks!
-Toby

tweaks_sav
Starting Member

2 Posts

Posted - 2008-03-05 : 07:36:21
Any ideas?
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-03-05 : 08:24:39
SP2 stays in memory. Had this problem when I first installed SQL on vista. Took me two days to get it sorted.

You need to makes sure all parts of SQL are uninstalled, including MSXML 6.0, MSXML 4 SP2 and SQLXML4. YUou may need to go to Local Machine\software\microsoft\ and remove the MSSQLServer key.

Then re-install and make sure you install SQL Server first as VS installs express and then tries to upgrade it straight away, therefore installing SP2.
Go to Top of Page
   

- Advertisement -