.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Your upgrade is blocked.. when adding components to SQL 2005 Standard Edition SP1

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

Upgrade SQL 2005 standard Runtime edition to SQL 2005 standard edition full version

We have a MS SQL 2005 standard edition runtime license. The SQL Server Runtime license is a license that lets an independent software vendor (ISV) embed the complete SQL Server code into a solution for use only by the ISV application. The customers of the ISV cannot use this SQL Server product to run other applications or to develop new applications, databases, or tables. Now we want to add a new database to the SQL. We know that we have to buy a full version of SQL 2008 standard edition. But the question is: How can we add a new database to the existing SQL. Do we have to uninstall SQL runtime license and install the full version and migrate the existing databse or can we change the key and add new databases to the SQL server?

SQL 2005 will not install blocked because of edition upgrade rules should I uninstall existing SQL?

SQL 2005 will not install   blocked because of edition upgrade rules    should I uninstall existing SQL?

SQL 2005 Standard to Enterprise Edition upgrade on existing three-node cluster


Current set-up: three node cluster running Windows Server 2003 Enterprise Edition SP2 with two instances of SQL Server 2005 Standard Edition SP2.


Virtual node 1: Standard Edition, default instance, Database Engine only

Virtual node 2: Standard Edition, named instance, Database Engine, Analysis Services and Integration Services


Physical node A: Prefered node for virtual node 1

Physical node B: Failover node for both virtual node 1 and 2 (thus having two installations of Standard Edition)

Physical node C: Prefered node for virtual node 2


We started off with this set-up because there was no need for Enterprise features, and SQL 2005 supports failover clustering with two nodes in Standard Edition. Saved a bundle of cash, so everybody's happy. Now we need to run a solution on virtual node 2 that requires Enterprise features in Analysis and Integration Services, so an edition upgrade is required on virtual node 2. I have done some research and found several edition upgrade examples, but none that match the above scenario. We are running production on these machines, so I can't risk experimenting with command line options, I have to be right the first time.


Is it possible to mix two editions of SQL Server 2005 in one cluster? Can I upgrade virtual node 2 to Enterprise but leave virtual node 1 at

2005 Enterprise upgrade to 2008 Standard?

We are currently running 2005 Enterprise Edition. Is it possible to move the database to 2008 Standard Edition?  

Upgrade Desktop Engine (MSDE 2000) to standard Edition 2000

Hi All,   I need to upgrade from MSDE to SQL server 2000 Standard Edition how can we proceed with this. I am new to this and any help will highly appreciated. What are the things i should take care before going to this version up gradation ?

Replication option SQL 2005 Standard Edition

Hi, We are using SQL 2005 Standard Edition.  We would like to use Replication for one of our database. I would like to know answers for the questions. 1. Can we use Replication features with SQL 2005 Standard Edition 2. Can we use DR site with replication for the reporting purpose?  Is there any risks associated with option? 3. Do we still need to take transaction log backup on the production server if we use replication.   Thanks.      

SQL 2005 Express Edition with Advanced Services - Upgrade SP3

Hi On my Windows 2003 server, I have SQL 2005 Express Edition with Advanced Services -  2005.90.3042.0 I need to upgrade to SP3. I downloaded the  SQL 2005 Express Edition with Advanced Services with SP3 and ran it. It has an error: UpgradeAdvisor returned -1 Please help

SQL Server 2005 standard Edition to SQL Server 2005 enterprise edition



My current version of SQL server is Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I want to upgrade this to Enterprise edition. I would like to know the below information please

  • step by step instructions on how to perform this upgrade
  • I have databases & replications setup on this server. Will the upgrade have any adverse effects on the current replication setup?

Any help and guidance is truly appericiated. Thanks.

SQL Server 2005 Standard edition install fails; An instance with the same name.../


Good Morning

I am trying to install SQL Server 2005 onto Windows Server 2003 Small Business Edition. Previously SQL Server 2000 from the SBE disk was installed, automatic updates are enabled.

I have selected the default instance and everything I try results in the error:

An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

Log file says;

Machine         : ISAINTERNET
Product         : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_ISAINTERNET_SQL.log
Last Action     : DetectInstanceClash
Error String    : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number    : 28086

Ian Smith

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise


We moved our databases to new hardware today (using copy database wizard)


The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m

Upgrade SQL Server 2008 Standard Edition to 2008 R2

I'm trying to find the right down load to use to upgrade SQL Server 2008 Standard Edition to Standard Edition R2.  This is the first upgrade I've done for SQL Server and I can't find any download for R2 that is specifically for Standard Edition.  Can anyone point me in the right direction please?

SQL 2005 will not install because of edition upgrade rules do I need to uninstall existing SQL "lite

SQL 2005 will not install because of edition upgrade rules.  Do I need to uninstall existing SQL "lite"?

Unexpected failure during the setup of SQL Server 2005 Standard Edition


Dear All

When I was installing the SQL Server 2005 Standard Edition on Windows Server 2003, the following problem occured.

How can I solve it?

Thank you so much!


TITLE: Microsoft SQL Server 2005 Setup

There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.10%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643



Unable to "upgrade" SQL 2008 Enterprise to Standard Edition - Error: the credentials you provided fo


I already tried changing the logon account for SQL services and still receive the error.

Please help.

how to upgrade moss 2007 standard edition from enterprise trail version.



i have one problem in my server.

it's trial version is expired.

Initially we deploy a trial version of moss 2007 enterprise edition.

Now i have moss 2007 standard edition with key, but it's not work on server.

Kindly suggest how to activate  standard edition.

and i want to switch SQL server to another server which is presently on same server.

Please response asap.

Ankit jain



SSAS 2005 Standard Edition dimensional data security

I am trying to setup a security role that will be based on specific values in a dimension.  We are currently using 2005 SSAS Standard edition.  Does standard edition allow this or will we need Enterprise edition?  This is not working when we test this out.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend