John: Thanks for your input!

No need to failover before rebooting the second node?

Thanks a lot!

Thanks. So when windows reboot, does the sql server service comes online automatically?

Thanks! I would go with your recommendation.

Thanks Gila..do you think we need to keep the app offline for this operation.

Please see if these steps are good to follow:

STEPS: (SP upgrade - 2005 Cluster)

1.) Move both instances on one node (if active/active)

2.) Run the patch files from active node

 Installer automatically...

Does it mean we run SP installer from active node?

Thanks Steve for this post. I had similar issues like, I was able to connect remotely to sql server from another server within the domain but not from my laptop....

See if this script helps. I use this to script out users/roles/permissions before a db refresh.

DECLARE

@sql VARCHAR(2048)

,@sort INT

DECLARE tmp CURSOR...

Thanks a lot guys!!!

Thanks a lot guys... I forgot to mention that this dev environment is a VM. Does these drive recommendations still applies even if its in vm?

For dev environment d: for app, e: for data, f: for log, g: for tempdb and h: for backup is it too much im asking for?

Thanks Gail and Igor !

Thank you!