Your upgrade is blocked.. when adding components to SQL 2005 Standard Edition SP1
Name: Microsoft SQL Server 2005 Tools
Hello,
I am having a problem when trying to add the Client Components to an existing installation of SQL 2005 Standard Edition SP1 running on Windows 2003 Standard. The server was originally built with SQL 2005 Standard Edition and had SP1 installed at a later date. I am using the CD that SQL was originally installed with which is not a service packed copy of SQL. The reason given when clicking the details button is as follows:
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
Any help would be greatly appreciated.
Regards
Steve
I'm having the same problem here.
Hi,
Do you know if Microsoft can provide a CD for SQL 2005 Standard Edition with SP1 as it is not possible to overlay the service pack files onto the original source? Please let me know if you have any success solving this as I'm soon going to be under pressure to rebuild the server with the additional components and then service pack, which sounds like a lot of hassle!
Regards
Steve
You can only have one copy of Client Components installed on a machine. If setup blocks install/upgrade new copy of Client Components it is because there is already one copy installed. It is possible that the installed Client Components are from Express SKU. When you want to upgrade to higher SKU you have to use original installation media those are without SP. If you have Client Components already on SP level upgrade is blocked because installed product is higher version but if you want to perform SKU upgrade it is possible to do so but it means upgrading from lower SKU and higher version to higher SKU and lower version so after upgrade you have to apply SP. To perform such upgrade you have to specify SKUUPGRADE=1 on command line when you launching setup from the original media:
E:\Servers\setup.exe SKUUPGRADE=1
BTW: You should see this as a warning on System Configuration Check page.
I gave this a shot, but still couldn't get it to install.
- I had SQL Express 2005 installed.
- Also have VS.NET 2005 installed.
- I uninstalled all components of SQL Server (but not VS.NET).
- Then I ran the SQL 2005 Developer CD and the Workstation components install failed with the message: Existing Components, etc.
- It says I have already have version 9.1.2047.00 of the components installed.
- Cancelled and repeated the install process with theSKUUPGRADE flag
- Same Result.
Any ideas? It still seems to think I have SQL installed, but when I try to upgrade it doesn't work either. I get this block in the Details about the failure:
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Hi Michelle,
Is this still the case? I have a two instance server with SP1 on each instance.
I am trying to install the BIDS workbench and am getting the same issue.
Attempted SKUUPGRADE =1 and this didn't work.
Got this error message although System Configuration Checker SCC did pass ok.
================================
Name: Microsoft SQL Server 2005 Tools
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
=================================
I could possibly remove one of the instances but not the SMS server.
Where do i go from here?
Regards, Brian
First go to Add/Remove Programs in Windows XP or Uninstall a program in Vista and select to uninstal SQL Server 2005. It will start the uninstall process but will let you choose what you want to uninstall. So select only workstation components. Uninstall them and then reinstall them from whereever you want. I had the same problem running SQL Server Management Studio Express and wanted to install the fully functional SQL Server Management Studio from SQL DVD and it was blocked. Removed everything from SQL Native client to workstation components, leaving only SQL Server 2005 database on the computer because I had online databases there. Install went on without a problem.
regards,
markoh
I'm having this same problem. I have Visual Studio 2005 SP1 with SQL Server Express installed, and when I installed SQL 2005 Development edition the management tools would not install.
This seems to be an issue if you have SQL Server Express installed (it does not come with the management tools). I have tried the suggestions given so far, but none of them work. I finally uninstalled the sql mobile development tools that install with Visual Studio 2005 and reinstalled SQL Server 2005. This seems to work.
I would recommend installing SQL 2005 before Visual Studio 2005 to avoid issues. If you have to install SQL 2005 after VS 2005, follow the above procedure.
SKUUPGRADE did
not work for me. Removing the Mobile Tools did
not work for me.
The only thing that did work for me was the "partial uninstall" procedure as described by
markoh/mh8759:
- Add/Remove Programs | Uninstall Microsoft SQL Server 2005
- Select to only remove the client tools (unchecked remove existing instance)
- Start installation (I ran it finewithout the SKUUPGRADE switch)
My situation that had me blocked:
Vista Ultimate x64
default Visual Studio 2005 install (including SQL Express)
VS2005 SP1 applied
Trying to install SQLS2K5 Dev Edition x64
After following the partial uninstall of SQLServer Express (VS2005SP1), setup of the Dev Edition was able to continue.
Same problem on several servers with SQL Server SPII installed
Also same problem on server with Visual Studio installed
Had to uninstall Visual Studio
Had to Run setup SKUUPGRADE=1
Thanks for good advise
I belive MS could have done a better job - these problems must have induced millions of workhours 'round the world
I totally agree with John Bailey and would like to add:
Install ALL components of SQL Server BEFORE upgrading SP and BEFORE installing Visual Studio
Many thanks for your post. I have spent many frustrating hours on this problem until I stumbled on your solution.
We have a x64 install of sql2005 and when I get the error message 'your upgrade is blocked.... the screens indicatges that the version I have is 9.0.2047 but the sql error message tells me is version
LinkID 20476
Product Name Microsoft SQL Server
Product Version 9.00.1399.06
Message Source setup.rll
Message ID SQLSetup90
EvtType 28108
di I have a different/biger problem?
