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

Who is online?  179 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


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

View Manohar Punna 's profile

Comments (1)

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



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 my earlier blog, I just explain about the importance of filtered indexes. Link for that blog is mention below:
  • 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. ...
  • Hello, Constraints can be defined as rules that govern the values that are inserted into a column. These rules help in enforcing data integrity. For example if a NOT NULL constraint is defined over a ...