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

23 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
  11. Thanks for the good writeup. It in reality was once a enjoyment account it. Glance complex to more brought agreeable from you! By the way, how can we be in contact? established digital marketer

    ReplyDelete
  12. There is perceptibly a bundle to know about this. I think you made certain nice points in features also.
    best printing services singapore

    ReplyDelete
  13. I am only writing to make you be aware of what a perfect experience my friend's girl developed browsing the blog. She came to understand lots of details, most notably what it is like to have a wonderful helping mindset to make men and women quite simply completely grasp specified impossible subject matter. You really did more than our expected results. Thanks for rendering these priceless, dependable, explanatory as well as cool guidance on that topic to Emily. advertising platforms

    ReplyDelete
  14. Hi, Neat post. There's a problem with your site in internet explorer, would check this… IE still is the market leader and a large portion of people will miss your great writing due to this problem. advertising agencies

    ReplyDelete
  15. Of course, what a magnificent website and illuminating posts, I will bookmark your blog.All the Best! digital marketing campaigns

    ReplyDelete
  16. Hey there! This is my first visit to your blog! We are a group of volunteers and starting a new project in a community in the same niche. Your blog provided us useful information to work on. You have done a wonderful job! responsive website design

    ReplyDelete
  17. Good day very cool web site!! Man .. Beautiful .. Wonderful .. I will bookmark your site and take the feeds additionally…I am glad to find a lot of useful info here in the post, we want work out extra techniques on this regard, thanks for sharing. . . . . . You need to create content that is engaging

    ReplyDelete
  18. Spot on with this write-up, I actually think this web site wants way more consideration. I’ll most likely be once more to read way more, thanks for that info. Method to Replicate Competitor Links

    ReplyDelete
  19. Unquestionably consider that that you said. Your favorite justification appeared to be at the internet the simplest thing to be mindful of. I say to you, I certainly get annoyed at the same time as folks think about concerns that they plainly don't realize about. You controlled to hit the nail upon the top and defined out the whole thing without having side effect , other people can take a signal. Will likely be back to get more. Thanks skin clinic Singapore

    ReplyDelete
  20. I’m impressed, I need to say. Actually hardly ever do I encounter a weblog that’s both educative and entertaining, and let me tell you, you may have hit the nail on the head. Your idea is outstanding; the issue is one thing that not sufficient people are speaking intelligently about. I'm very joyful that I stumbled throughout this in my search for something relating to this.jaeger lecoultre melbourne

    ReplyDelete
  21. Hi, i think that i saw you visited my blog thus i came to “return the favor”.I'm attempting to find things to enhance my website!I suppose its ok to use a few of your ideas!!
    How SEO And UX Work Together

    ReplyDelete
  22. Do you mind if I quote a few of your posts as long as I provide credit and sources back to your site? My website is in the exact same area of interest as yours and my users would really benefit from some of the information you provide here. Please let me know if this ok with you. Many thanks!
    Still looking for a good website designer?

    ReplyDelete
  23. Youre so cool! I dont suppose Ive learn anything like this before. So good to search out anyone with some original thoughts on this subject. realy thank you for starting this up. this web site is one thing that is needed on the internet, someone with a little originality. useful job for bringing one thing new to the web!
    media agency singapore

    ReplyDelete