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

42 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. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. There is perceptibly a bundle to know about this. I think you made certain nice points in features also.
    best printing services singapore

    ReplyDelete
  12. 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
  13. 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
  14. Of course, what a magnificent website and illuminating posts, I will bookmark your blog.All the Best! digital marketing campaigns

    ReplyDelete
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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
  23. Wow, wonderful blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is fantastic, let alone the content! Stainless Steel Sheet

    ReplyDelete
  24. I think this is among the most important information for me. And i'm glad reading your article. But wanna remark on some general things, The site style is great, the articles is really excellent : D. Good job, cheers. cetaphil

    ReplyDelete
  25. Wow, fantastic blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is excellent, as well as the content! events furniture rental

    ReplyDelete
  26. This was a shocking post. It has some look at here fundamental data on this subject. https://serverbrowse.com/

    ReplyDelete
  27. When you’ll complete microsoft certified solutions expert server infrastructure course fully you can configure advanced windows, designing and implementing a server infrastructure. So go ahead with ABCO Technology without any confusion.

    ReplyDelete
  28. Following ideas could give you a different mind-set regarding that gorgeous lustre. bulk craft glitter

    ReplyDelete
  29. I'm extremely impressed with your writing skills as well as with the layout on your blog. Is this a paid theme or did you customize it yourself? Anyway keep up the excellent quality writing, it is rare to see a nice blog like this one these days.Google Home

    ReplyDelete
  30. Heya i am for the first time here. I found this board and I find It truly useful & it helped me out a lot. I hope to give something back and aid others like you helped me. mitsubishi aircon service

    ReplyDelete
  31. I should show thankfulness to the author only for rescuing me of this sort of issue. Due to exploring through the web indexes and seeing ideas which were not amazing, I accepted as long as I can remember was well finished. Existing without the responses to the issues you have addressed because of your post is a basic case, just as the ones which may have in a negative manner harmed my profession in the event that I had not gone over your blog. Your essential capacity and benevolence in contacting all the things was useful. I don't have a clue what I would have done on the off chance that I had not experienced such a point this way. I am ready to right now look forward to my future. You rock particularly for this expert and stunning assistance. I won't be hesitant to prescribe your blog to any person who ought to get care about this zone.

    apartment cleaning service

    ReplyDelete
  32. I should show thankfulness to the essayist only for rescuing me of this sort of issue. Due to exploring through the web crawlers and seeing ideas which were not amazing, I accepted as long as I can remember was well finished. Existing without the responses to the issues you have tackled because of your post is a basic case, just as the ones which may have in a negative manner harmed my vocation in the event that I had not gone over your blog. Your essential capacity and graciousness in contacting all the things was useful. I don't have a clue what I would have done in the event that I had not experienced such a point this way. I am ready to as of now look forward to my future. You rock particularly for this expert and astounding assistance. I won't be hesitant to prescribe your blog to any person who ought to get care about this zone.

    energy drinks brands

    ReplyDelete
  33. Awesome site you have here yet I was contemplating whether you was aware of any client conversation discussions that cover similar points discussed here? I'd truly prefer to be a piece of online network where I can get reactions from other learned individuals that share a similar premium. In the event that you have any recommendations, if it's not too much trouble let me know. Like it!safe box singapore

    ReplyDelete
  34. Do you mind if I quote two or three your posts as long as I give credit and sources back to your weblog? My blog website page is in a correctly similar area of interest as yours and my visitors would really benefit by a part of the information you give here. On the off chance that it's not all that much difficulty let me know whether this okay with you. Thankful to you!

    custom made wardrobe Singapore

    ReplyDelete
  35. I simply wanted to develop a brief message in order to appreciate you for all the awesome secrets you are giving out at this site. My extensive internet investigation has now been paid with brilliant insight to go over with my friends. I would state that that many of us visitors are truly lucky to live in a really good community with many marvellous individuals with insightful concepts. I feel really blessed to have seen your weblog and look forward to so many more awesome times reading here. Thank you once again for all the details.bed linen singapore

    ReplyDelete
  36. I have to show my thanks to this writer just for rescuing me from such a predicament. Because of looking out through the search engines and obtaining strategies which are not beneficial, I assumed my life was gone. Living without the presence of answers to the problems you have fixed by means of the website is a serious case, and the ones which may have in a negative way affected my career if I had not come across your blog. Your own personal expertise and kindness in controlling all the stuff was priceless. I'm not sure what I would have done if I had not come across such a subject like this. I can also at this time relish my future. Thanks for your time so much for the reliable and amazing guide. I will not be reluctant to recommend your web sites to any individual who should have tips on this subject matter.cheap sk2 singapore

    ReplyDelete
  37. Good write-up, I am regular visitor of one’s blog, maintain up the excellent operate, and It's going to be a regular visitor for a long time.exhumation services singapore

    ReplyDelete
  38. My brother suggested I would possibly like this blog. He was totally right. This put up actually made my day. You can not consider simply how much time I had spent for this information! Thank you!influencer marketing agency

    ReplyDelete
  39. Hi there, just became aware of your blog through Google, and found that it is really informative. I’m going to watch out for brussels. I’ll be grateful if you continue this in future. Many people will be benefited from your writing. Cheers!personalised notebooks

    ReplyDelete
  40. In the awesome pattern of things you secure a B+ just for effort. Where you confused everybody ended up being on your specifics. As they say, details make or break the argument.. And that could not be much more accurate in this article. Having said that, permit me inform you exactly what did deliver the results. Your writing can be quite powerful and this is most likely the reason why I am making the effort in order to opine. I do not make it a regular habit of doing that. Second, whilst I can see a jumps in reason you make, I am not sure of just how you appear to unite your details which in turn make your conclusion. For now I will, no doubt yield to your point but trust in the foreseeable future you actually link the dots much better.Profibus/Profinet

    ReplyDelete
  41. We are a group of volunteers and opening a new scheme in our community. Your web site offered us with valuable info to work on. You've done a formidable job and our entire community will be thankful to you.cheapest personal loan Singapore

    ReplyDelete