Sunday, July 31, 2011

Add or Remove a node in SQLServer 2005 Failover Cluster

You need to follow the steps in case of adding or removing a node in a cluster or recover a failed node in a failover cluster environment. In case of node1 failure, the SQL Server failover cluster fails over to node2. Use Cluster administrator to evict node from cluster.

You may receive following error while adding or removing a node to the existing cluster.

Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine.

Error message from event log:-

"SQL Server Remote Setup .job" (setup.exe) 5/20/2011 10:15:00 PM ** ERROR **
Unable to start task.
The specific error is:
0×80070005: Access is denied.


Solution: You might be connected via Remote Desktop and you may have some active remote desktop session. Please note that you must close all your RDP sessions before proceeding to installation.

To add or remove a node you must be a local administration on all the nodes of the failover cluster.

Step 1. Add a node to the Cluster
• Assign the quorum
• Run Add node wizard in Custer administrator from new node
• Provide Cluster service account password to add the node
• On the New Node assign the clustered drives used by SQLServer and verify the node recognizes the cluster drives
• The drive where you install SQLServer should have same driver letter as other nodes

Step 2. Add or remove a node in SQL Server 2005 Cluster
• Login to the surviving Node or active node of the SQLServer Cluster
• Click Add or Remove Programs in Control Panel
• Select the Microsoft SQL Server 2005 and click change
• The SQL Server 2005 Installation Wizard starts
• On the Component Selection page, select the SQL Server 2005 instance name to change and click next
• On Feature Maintenance page select a Database Engine component to change and click next
• SQL Server 2005 System Configuration Checker starts
• On the Microsoft SQL 2005 Welcome screen click next
• The System Configuration Checker scans the existing configuration on the computer
• Review the warnings and error messages, correct the errors as needed and click next
• On the Change or Remove Instance page, click Maintain the Virtual Server.
• On the Cluster Node Configuration page select the node from the available nodes list and click add . To remove a node from the failover cluster, select the node and click remove.
• In Remote Account Information, provide the password of the user currently logged in(This user should be a local admin on all the nodes) and click next
• Enter the service account username/password for each listed service and click next.
• On Error and Usage Report page, do not select anything and click next
• On the Ready to Install page, click install
• On the Completing the Microsoft SQL Server Installation Wizard page, you can review the summary log by clicking on the link provided. To exit from Installation wizard click Finish.

Step 3.Install the Workstation Components and Service packs
• Run the setup.exe from Installation CD or software dump
• Install only workstation components (note that these are not part of the cluster)
• All nodes in a failover cluster must be at same service pack version, install the service packs as same as servicing node or active node.

Regards,
Satishbabu Gunukula
http://www.sqlserver-expert.com

10 comments:

  1. Hello sir, Are you ok? You have written a unique content.

    It is very well information about on sqlserver-expert.com. It is very helpful in using social media sites.All people always want to know all about things that you have been described. It is very valuable & very nice posting! I will bookmark this blog as I have Greater Eviction Service Solutions provides fast, efficient, and professional eviction services for property owners in Austin, Florida. Demand an eviction these days.


    Thank You Very Much For a Nice & Cool Article.

    ReplyDelete
  2. Hi there, I found your blog via Google while searching for such kinda informative post and your post looks very interesting for me.writers have great importance in the writing company because they are the ones who solve customer's problems with respect to their needs. write my essay

    ReplyDelete
  3. Hmm it looks like your site ate my first comment (it was extremely long) so I guess I'll just sum it up what I submitted and say, I'm thoroughly enjoying your blog. I as well am an aspiring blog writer but I'm still new to the whole thing. Do you have any recommendations for rookie blog writers? I'd genuinely appreciate it. SEO consultancy Singapore

    ReplyDelete
  4. I do not even know how I ended up here, but I thought this post was great. I don't know who you are but certainly you are going to a famous blogger if you aren't already ;) Cheers! custom website design services

    ReplyDelete
  5. Nice blog here! Also your web site loads up very fast! What web host are you using? Can I get your affiliate link to your host? I wish my website loaded up as fast as yours lol
    seo consultant

    ReplyDelete
  6. I eventually settled on Senior Marketing Consultant because the 'Senior' implies my status within the hierarchy and 'Consultant' essentially encompasses my active role to my clients within the company.

    online ad spend

    ReplyDelete
  7. Hey just wanted to give you a quick heads up and let you know a few of the images aren't loading correctly. I'm not sure why but I think its a linking issue. I've tried it in two different web browsers and both show the same results.
    office bag for men

    ReplyDelete
  8. Magnificent beat ! I would like to apprentice while you amend your web site, how could i subscribe for a blog web site? The account helped me a acceptable deal. social media marketing

    ReplyDelete
  9. They also have a 100% acceptance rate if you show any promise in the feild, however they strongly strongly encourage a Portfolio.

    Redmart groceries

    ReplyDelete
  10. Wow, fantastic blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is great, as well as the content! sem services in singapore

    ReplyDelete