Friday, May 30, 2008

None of the selected features can be installed or upgraded. Setup cannot proceed since no

While installing Microsoft SQl 2005 you may face this message...

TITLE: Microsoft SQL Server Setup------------------------------
None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108
------------------------------BUTTONS: OK------------------------------
To solve this problem:
To get around this issue, run the setup.exe from the SQL installation source from your Run command with the parameter SKUUPGRADE=1 or UPGRADE=1.
For more ref
Hope this helps you people!

2 comments:

Tyler Larson said...

Didn't work for me. However, there's a Channel 9 forum thread about it. Essentially, if you installed SQL Server Express first, then you may run into this problem. Uninstall SQL Server and Express, then re-install SQL Server, and it will also install the tools.

Unknown said...

Go to "Add or Remove Programs". Select "Change" (NOT "Remove") on SQL Server 2005, and step by step remove all components over there. If you have installed more then one SQL servers, maybe we will need to intall Clients component again, and then repeat everything from the begining for the next server.

ASP.NET MVC - Sport Facility Booking system

  The project relies on some external service providers. Thus accessing them via their API requires authentication. An API Key need to be su...