"None of the selected features can be installed" error on SQL 2005 Cluster

_{Sunday, March 12, 2006 1:01 AM}

Hey All,

I installed SQL 2005 on a cluster.  Everything on the primary node works fine.  However, as the documentation suggests, the SQL Management Studio (and other tools) are not installed on the standby node by default.  However, when I go to try and install on the 2nd node I get the following error:

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

The link is referencing something about requiring a complex SA password.   I can verify that the directory structure on node 1 where the management studio and client tools exist does not exist on node 2.   I'm at wits end here, I've tried uninstalling/reinstalling/everything.

Anyone have any ideas?

thanks!

_{Tuesday, March 14, 2006 6:55 PM ✅Answered}

I finally figured it out...   Although the original install didn't actually install any of the tools on the 2nd node, it did create a "tools" directory on the 2nd node.  I renamed this directory and then went to try and install the tools and it worked.  Evidently the SQL setup was just looking to see if this directory existed.

_{Friday, December 5, 2008 11:18 AM}

Hello,

The sugesstion above did not help me unfortunately. However, since I only want to use SQL Server 2005 and no other SQL Server version earlier, I decided to clean up my computer from SQL Server for good. Once I have cleaned up my comp. it was like SQL Server never touched my computer. (Clean up the directories related to sql server inside Program Files also) And after this (restarting computer), I ran the SERVER setup.exe (Not the Tools for those anyone who started the setup from Tools or Server folder instead of main setup), in Advance section of the installution, I chose both Server and Client tools. After that everything went smooth (Except the once small error occured during the removal of the backup files of the setup but this didnt effect at all so if you run into this don't mind).

Basically, clean everything from your computer related to SQL Server (using Control panel > Add/Remove Programs is a good tool for that) and install the sql sever 2005 in a usual way using Advance section that you'll see during the installution.

I've suffered enough of this situation so I wanted to help for those who needed.

Regards,

_{Monday, May 4, 2009 4:24 AM | 1 vote}

Hello,

I tried to install MICROSOFT SQL SERVER 2005 EVALUATION EDITION (trail) and I got the same error when installing TOOLS.

I resolved it..

1. Remove worstation componenets through Control panel > Add/Remove Programes > SQL server 2005.

And installed TOOLs it will run.

Regards,

_{Monday, October 26, 2009 4:58 PM}

G. Vijaya Krishna's Answer worked !

Cheers !

_{Sunday, January 24, 2010 6:35 PM}

Mr Krishna's answer worked for me also!

Thanks!

Martin

_{Tuesday, July 27, 2010 8:24 AM}

Mr Krishna's answer worked for me also!

Thanks.

_{Tuesday, August 31, 2010 5:24 AM}

Thanks Vijaya....

 Remove worstation componenets through

1.) Control panel > Add/Remove Programes > SQL server 2005.

2.) Install Tools 

Works for me tooo

_{Monday, October 4, 2010 1:56 AM}

Thanks for your suggestion. It works Great

_{Thursday, October 20, 2011 10:30 AM}

Thanks!!, It worked like a charm..

Cheers!!

Thanks & Regards P.Venkateswara Reddy

_{Tuesday, September 18, 2012 6:15 AM}

Thanks a lot. This worked for me.