Cluster resource 'SQL Server' in clustered service or application '[ServerName] (MSSQLServer)' failed.

Who is online?  83 guests and 0 members
home  »  blogs  »  Manohar Punna  »  Cluster resource 'SQL Server' in clustered service or application '[ServerName] (MSSQLServer)' failed.
  Rate This Blog Entry:  register  or  login

Author

manu0417 Manohar Punna (Member since: 7/25/2012 2:36:32 PM)

View Manohar Punna 's profile

Comments (1)

user198487
2/18/2013 10:51:58 AM user198487  said:

{The version of the file is of SQL 2008 SP2. Later I realized that the server was first installed with SQL 2008 when it was a stand-alone machine. It was uninstalled and added to a cluster and we were trying to install SQL 2005 over it. Somehow the file was still there and that is creating the problems now. The SQL 2005 Native client could not connect to the 2008 version DLL file and was not allowing the cluster resource to come online. We can solve this issue by two methods.}

 When we unintall higher version SQLServer from cluster SQLSrvres.dll is not downgraded to lower version or removed (DLL is placed in standalone installation as well and not removed during uninstall). So you need to ensure that you have same version of SQLNative client as your resource dll else the ISAlive check will fail. Details http://mssqlwiki.com/2012/01/31/sql-server-resource-fails-to-come-online-is-alive-check-fails/

 

by

Leave a comment


 
Type the characters:
 *
 
   

SQLServerGeeks FaceBook group

SQLServerGeeks Events

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Manohar Punna's latest blog posts

Blogs RSS Feed

Latest community blog posts

  • Hi Friends, In this blog post, let’s have an insight on how Auditing can be done in SSIS packages? The basic auditing in package includes measures like How many rows were inserted, updated or de...
  • Hi SQL Geeks, Here are the blog posts by Piyush Bajaj for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at ht...
  • Hi SQL Geeks, Here are the blog posts by Ahmad Osama for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at htt...
  • Hi Friends, Are you facing any issue on SQL Server 2014 while running the same query which is running fine on previous version of SQL Server? If answer is yes then this may be due to the change in SQL...
  • I have written a SQL Server Change Data Capture GUI interface to facilitate for CDC operations. The project is hosted here https://sqlcdcapp.codeplex.com/ . Feel free to download, review and suggest c...
  • Recently I came across an interesting deadlock scenario I wasn’t aware off. I didn’t have idea that foreign key constraint can also result in deadlocks. The detailed steps to replicate the...
  • Hi Friends, In my earlier blog, I just explain about the importance of filtered indexes. Link for that blog is mention below: http://sqlservergeeks.com/blogs/princerastogi/personal/599/filtered-indexe...
  • A few words about the technology of our site. It's easy to take technology for granted, to focus on content and pay no attention to how it is being delivered. Typically we would encourage this focus. ...