SQL-Server resource fails to come online IS Alive check fails
Posted by Karthick P.K on January 31, 2012
SQL-Server resource fails to come online with below Error:
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 35; message = [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible.
Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Resolution:
Look at the version of (c:\windows\system32\sqsrvres.dll) and install the same version of SQL Server native client.
Cause:
When Higher version of SQL-Server is installed on a cluster in which lower version of SQL Server is already installed, the lower version SQL Server Resource DLL (c:\windows\system32\sqsrvres.dll) is upgraded to higher version and Higher resource DLL will be loaded by the resource monitor process to monitor Lower version as well.
For example: The Denali SQL Server Resource uses SNAC 11.0 to connect to the SQL instance and because SNAC 11.0 can be used to connect to Shiloh, Yukon and Katmai as well this side by side configuration will work. However if Denali is uninstalled, the Denali SQL Server resource DLL is not downgraded to Katmai, Yukon or Shiloh version and hence care should be taken to not uninstall SNAC 11.0 otherwise Yukon or Shiloh instance cannot be brought online.
Similarly When we install Yukon and Shiloh together, Yukon SQL Server Resource uses SNAC to connect to the SQL instance and because SNAC can be used to connect to Shiloh as well this side by side configuration will work. However if Yukon is uninstalled, the Yukon SQL Server resource DLL is not downgraded to Shiloh version and hence care should be taken to not uninstall SNAC otherwise Shiloh instance cannot be brought online.
If you liked this post do like us on Facebook at https://www.facebook.com/mssqlwiki and join our Facebook group MSSQLWIKI
Thank you,
Karthick P.K |My Facebook Page |My Site| Blog space| Twitter
Disclaimer
The views expressed on this website/blog are mine alone and do not reflect the views of my company. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.
This entry was posted on January 31, 2012 at 8:55 PM and is filed under Configuration, Connectivity, SQL General, SQL Server Cluster. Tagged: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible., ISAlive failure, SQLServer Cluster, SQLServer Resource not comming online, [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 35; message = [Microsoft][SQL Server Native Client 10.0]. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
MSSQLWIKI 
Ladha said
thanks, saved my life 🙂
Emilson Barbosa Bispo said
I dont find the “sqlsrvres.dll” file in my server. I check in another server but i cand find it too.
Karthick P.K said
In which folder you are checking?
Emilson Barbosa Bispo said
I searched c:\windows\system32 as you suggested. Also searched the entire disks without success.
Karthick P.K said
My bad, I have misspelled the name. It is “sqsrvres.dll” my apologies for mistake.
Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said
[…] SQL-Server resource fails to come online IS Alive check fails […]
Ajesh said
Hi,
I installed SQL server 2012 in cluster environment with active/passive node. Then i uninstalled it again for some reason. Now when i am trying to re-install again, I am getting this error-
The cluster resource ‘SQL Server Agent’ could not be brought online. Error: There was a failure to call cluster code from a provider. Exception message: Generic failure . Status code: 5023. Description: The group or resource is not in the correct state to perform the requested operation.
How to solve this issue.?
Philipp said
I usually do not drop a leave a response, but I browsed
a few responses on this page SQL-Server resource fails to come online IS Alive check
fails MSSQLWIKI. I actually do have a few questions for you if you
do not mind. Could it be just me or do some of the
responses come across like they are left by brain dead people?
😛 And, if you are writing at additional online social sites,
I’d like to follow you. Could you list of every one of your social sites like your linkedin profile, Facebook
page or twitter feed?