Its my Organizations policy to add a new Cluster Security Group for every installation and then register the same domain accounts.

Mostly the workflow is where I install the SQL cluster...

I suppose that this can be made easy using powershell but what exactly do you mean by saying that you want to adjust the memory allocation for the nodes.

I am...

Below is the code that I used with a few adjustments where i again consider that I have a SQL cluster T500\ABCDE hosted by two nodes T500A and T500B where...

Thanks for all the suggestions from all, although I tried but I think I failed in explain my approach. In my case the failover never happens from the active node...

Ill try and refine what I am exactly trying to do.

I need to copy some files on every node of a SQL server clustered server service. The files to be...

Hi Wayne,

That actually is not an approach that I can follow cos my intention is to get the Cluster server name from a node name but the approach provided by...

what exactly do you mean when you specify that you need to run it on the instance. Can you provide an example of the instance name on which you want...

Well using the mentioned, I can not run it on a server and get the drive info of a remote server. as when this will be execute it will collect...

Hi e-ghetto,

Appreciate your effort for writing the script but as I mentioned that I do not have powershell 2.0 on my server environment. The WMIobject class and -computername attributes were...

I really feel foolish that I never noticed that I was not committing the changes made to the object.

Your point worked for me. thanks Mike.

SQLSErverCentral is really helpfull.

Hey Abhijit,

Well I just need a process to test it out. The Service Pack to be installed are already tested on different servers. I need a way to just automate...

Hi Ashish,

Yes actually you are correct on this but its not my Organisations policy, its a country specific policy due to which Administration access can not be provided to the...

Hello Again,

I might sound a bit stupid in changing what I problem faced but I am now able to process the cubes but the different applications that need to process...