SQL, 2005, Cluster service won't start

Posted on 2008-11-20
Last Modified: 2012-05-05
We have a sql cluster.  Originaly it was all working.  At some point the TCPIP stack on sql1 got corrupted.  After repairing the stack the cluster service will not start on that server.  This is a production system so we are concerned about evicting that server from the cluster and possibly losing the other server that is still working and using the clustered drives.  One note:  while troubleshooting the TCPIP stack issue we removed the server from the domain.  It is now back in the domain.  Is it possible that removing it from the domain and putting it back in that we need to evict and add it back in to the cluster because the QUID changed?
Question by:NorthAmerican
    LVL 26

    Expert Comment

    did you change the cluster ip address resource?
    Try removing the ip address and cluster name resources from the cluster group and add them again. Dont forget the define dependecies, network name depends on ip address...

    Author Comment

    We have not changed the cluster IP address.

    Author Comment

    We evicted the node and are rebooting the server.  We will then attempt to add the node back in.  Hopefully that will fix the cluster service issue.

    Accepted Solution

    After the reboot we added the node back in and all went well!  Problem solved.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now