[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL, 2005, Cluster service won't start

Posted on 2008-11-20
4
Medium Priority
?
327 Views
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?
0
Comment
Question by:NorthAmerican
  • 3
4 Comments
 
LVL 26

Expert Comment

by:tigin44
ID: 23003508
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...
0
 

Author Comment

by:NorthAmerican
ID: 23003736
We have not changed the cluster IP address.
0
 

Author Comment

by:NorthAmerican
ID: 23003901
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.
0
 

Accepted Solution

by:
NorthAmerican earned 0 total points
ID: 23004011
After the reboot we added the node back in and all went well!  Problem solved.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Screencast - Getting to Know the Pipeline

873 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