Sunday, March 11, 2012

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

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!

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.

No comments:

Post a Comment