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:
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.
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.
Post a Comment