"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 description found" when saving a package

Hi everyone,

Primary platform is Framework 2.0 and Sql25k 64-bit

When I try to save my DTSX package from my client to the production server I get this error:

"No Description found"

Either Windows or Sql authentication.

Does anyone have ever faced this drawback?

Thanks in advance,

Any idea?

Is something related to Visio 2003? http://support.microsoft.com/kb/922546

Thanks again,

'OraOLEDB.Oracle.1' is not registered on local machine

Hi all of you,

Primary platform is Framework 2.0 running over XP.

I've got an issue with a SSIS package which uses Oracle Provider for OleDB:

Test connection failed because of an error in initializing provider 'OraOLEDB.Oracle.1' is not registered on local machine

Nevertheless, MS Ole DB Provider for Oracle works fine. Let me know where am I failing.

Thanks in advance,

Try reinstalling the Oracle client.|||

Thanks for your answer Phil.

I've got a question.. If I do such thing, my tnsnames.ora will be destroyed? 'suppose so

Anyway, I think that my problem is other one..

|||Copy your tnsnames.ora file to another name and then restore it when done. Which is something you should be doing anyway -- backing it up.

You can try just reinstalling the OLE provider: http://www.oracle.com/technology/software/tech/windows/ole_db/index.html|||

Hi Phil,

Thanks indeed. It works fine. I'm sorry for my scepticism.

|||

Hi Phil.

I am also having this problem, made sure that the ACL are read and execute for ASPNET, IUSR, IWAM users on the server. The app is .NET 2.0 by a vendor that is using the following connection string. names change to protect the innocent.

Provider=OraOLEDB.Oracle;Password=pass;User ID=user; Data Source=ds'/>

Unfortunately the vendor has no answers...

My question is that I have been told by my DBA that reinstalling doesn't always reinstall correctly as the registry entries still exists. Am I being told correctly? Also, If I reinstall, am I creating a new Oracle_Home that I would have set up in the OBDC administrator.

|||

n2magick wrote:

Hi Phil.

I am also having this problem, made sure that the ACL are read and execute for ASPNET, IUSR, IWAM users on the server. The app is .NET 2.0 by a vendor that is using the following connection string. names change to protect the innocent.

Provider=OraOLEDB.Oracle;Password=pass;User ID=user; Data Source=ds'/>

Unfortunately the vendor has no answers...

My question is that I have been told by my DBA that reinstalling doesn't always reinstall correctly as the registry entries still exists. Am I being told correctly? Also, If I reinstall, am I creating a new Oracle_Home that I would have set up in the OBDC administrator.

Right, but are you using SSIS? If not, I'm afraid I cannot help you... It seems that you have several layers that could be causing you issues.|||

Thanks Phil for answering my question. No I am not using SSIS. Just happen on the post doing a search trying to find the answer to my problem.

Thanks again for your prompt answer.

LuAnn

#8172 [error] need help

-- The following code throw exception~

-- Need HELP!!

use AdventureWorksgo--drop table T--gocreate table T(ProductModelIDint primary key, Instructionsxml (Production.ManuInstructionsSchemaCollection))goinsert Tselect ProductModelID, Instructionsfrom Production.ProductModelwhere ProductModelID=7goselect Instructionsfrom T--1) insert <Location 1000/>. Note: <Root> must be singleton in the queryupdate Tset Instructions.modify(' declare namespace MI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions"; insert <MI:Location LocationID="1000" LaborHours="1000" > These are manu steps at location 1000. <MI:step>New step1 instructions</MI:step> Instructions for step 2 are here <MI:step>New step 2 instructions</MI:step> </MI:Location> as first into (/MI:root)[1]')goselect Instructionsfrom Tdeclare @.aaaaaintset @.aaaaa=1000-- delete an attributeupdate Tset Instructions.modify(' declare namespace MI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions"; delete(/MI:root/MI:Location[@.LocationID='+@.aaaaa+']/@.LaborHours) ')--,--Instructions.modify('-- declare namespace MI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";-- delete(/MI:root/MI:Location[@.LocationID='+@.aaaaa+']/text()) --'),--Instructions.modify('-- declare namespace MI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";-- delete(/MI:root/MI:Location[@.LocationID='+@.aaaaa+']/MI:step[2]) --')goselect Instructionsfrom T-- cleanupdrop table Tgo

That means you can't use dynamic built string as the argument of modify method. You needsql:variable("@.var") function, for example:

update T
set Instructions.modify('
declare namespace MI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";
delete(/MI:root/MI:Location[@.LocationID=sql:variable("@.aaaaa")]/@.LaborHours)
')

To learn more about XQuery in SQL2005, you can refer to:

http://msdn.microsoft.com/library/en-us/dnsql90/html/sql2k5_xqueryintro.asp?frame=true

|||

Thx very very very very much