cluster install 2nd node unavailable

Hi all,

Try to install sql 2005 x64 on a Win2003r2 x64 two node cluster.
All looks fine as far I get to the "cluster node configuration" dialog.
My second node is always displayed as "unavailable node" reason "unknown".

- I checked the logfiles but could not find any error.
- Installation user & cluster user are both local admins.
- Tried with sql 2005 x32 version -> same result.

What do I miss out here?
Any help is highly appreciated.

TIA
acki

as mentioned above installing the sql 2005 x32 Version results in same state -> node unavailable reason unknown

If try to install sql 2000 x32 my two nodes show up as configured nodes installation would continue without errors.

Any help is highly appreciated !

TIA
acki

|||Check the SQL error log, cluster log and event viewer log for more information.|||

Satya,

None of the logs shows anything unusual !

|||Can you check thru this http://msdn2.microsoft.com/en-us/library/ms179530.aspx link and confirm whether you have following in same fashion.|||

Satya,
I know the mentioned kb article.
I'm not a newbe in installing sql server clusters, have done it a dozent times (x32) but never had troubles like this.

At the beginning setupjob checks BOTH nodes for possible installation. All looks fine there!
As mentioned already non of the logs (eventlog, clusterlog, sql inst. log) shows anything unusual or error (in my eyes).
Prerequisits and pre installation steps are all done...

The funny thing is installing a sql 2000 (x32) cluster would work (so there could nothing be wrong with the cluster inst.)

|||

ok, after setting up a packet sniffer and running behind the bits and bytes I finally found the solution to this problem.

Make sure the "Remote Registry" service is running on second (inactive) node!

HTH
acki

cluster install 2nd node unavailable

Hi all,

Try to install sql 2005 x64 on a Win2003r2 x64 two node cluster.
All looks fine as far I get to the "cluster node configuration" dialog.
My second node is always displayed as "unavailable node" reason "unknown".

- I checked the logfiles but could not find any error.
- Installation user & cluster user are both local admins.
- Tried with sql 2005 x32 version -> same result.

What do I miss out here?
Any help is highly appreciated.

TIA
acki

as mentioned above installing the sql 2005 x32 Version results in same state -> node unavailable reason unknown

If try to install sql 2000 x32 my two nodes show up as configured nodes installation would continue without errors.

Any help is highly appreciated !

TIA
acki

|||Check the SQL error log, cluster log and event viewer log for more information.|||

Satya,

None of the logs shows anything unusual !

|||Can you check thru this http://msdn2.microsoft.com/en-us/library/ms179530.aspx link and confirm whether you have following in same fashion.|||

Satya,
I know the mentioned kb article.
I'm not a newbe in installing sql server clusters, have done it a dozent times (x32) but never had troubles like this.

At the beginning setupjob checks BOTH nodes for possible installation. All looks fine there!
As mentioned already non of the logs (eventlog, clusterlog, sql inst. log) shows anything unusual or error (in my eyes).
Prerequisits and pre installation steps are all done...

The funny thing is installing a sql 2000 (x32) cluster would work (so there could nothing be wrong with the cluster inst.)

|||

ok, after setting up a packet sniffer and running behind the bits and bytes I finally found the solution to this problem.

Make sure the "Remote Registry" service is running on second (inactive) node!

HTH
acki

Clearing/Unselecting Multi-Value selections made

I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections?

Up to the top...

Come on now, where our options for this?!!!

Microsoft can do better than this.

|||

Ron,

Sorry to tell you but they took away the <select all> functionality in SP1. You now need to manually add an "All" option and account for it in the sql. I know, this is a huge disappointment and I cannot for the life of me understand how anyone with an ounce of sense would find this acceptable. It sucks. There are 5th tier reporting options that perform way better than this. This is one of the most basic reporting functions. First, we had to wait for the multi-select functionality and now they have gone and messed it up.

|||

Yes i understand and i have tried the workaround. It doesn't help with what i want.

What i want to do is be able to 'clear' all the previous selections made so i can make new multivalue selections without having to go down the list and uncheck the previous selections. Is there a way to do this? It wasn't just a select all, it was also an unselect all.

Clearing/Unselecting Multi-Value selections made

I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections?

Up to the top...

Come on now, where our options for this?!!!

Microsoft can do better than this.

|||

Ron,

Sorry to tell you but they took away the <select all> functionality in SP1. You now need to manually add an "All" option and account for it in the sql. I know, this is a huge disappointment and I cannot for the life of me understand how anyone with an ounce of sense would find this acceptable. It sucks. There are 5th tier reporting options that perform way better than this. This is one of the most basic reporting functions. First, we had to wait for the multi-select functionality and now they have gone and messed it up.

|||

Yes i understand and i have tried the workaround. It doesn't help with what i want.

What i want to do is be able to 'clear' all the previous selections made so i can make new multivalue selections without having to go down the list and uncheck the previous selections. Is there a way to do this? It wasn't just a select all, it was also an unselect all.