Skip to main content
NetApp Knowledge Base

SCSQL backup fails with error "No SQL resource is discovered on the host"

  1. Last updated
  2. Save as PDF
Views:
735
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • SnapCenter Plugin for SQL (SCSQL) 4.x
  • Microsoft SQL Always On Availability Group (SQL AG)
  • Microsoft SQL Failover Cluster Instance (SQL FCI)

Issue

  • SnapCenter does not show databases that are part of a SQL AG/FCI as available for backup in the Resources pane and the backups fails with error, "No SQL resource is discovered on the host. Check SQL resource(s) state on the host”
  • The SnapCenter SQL discovery logs show an “Access Denied” error returned to a WMI query to enumerate the cluster network resources:
 
C:\Program Files\NetApp\SnapCenter\SnapCenter Plug-in for Microsoft SQL Server\log\Smsql_<JOB ID#>
 
2022-08-05T07:00:18.2306069-05:00 DEBUG SmSql_<JOB ID#> PID=[XXXX] TID=[66] Resource: SELECT * FROM MSCLUSTER_RESOURCE WHERE Type = "Network Name"
2022-08-05T07:00:19.2149795-05:00 ERROR SmSql_<JOB ID#> PID=[XXXX] TID=[66] An unexpected error occurred while retrieving the Cluster Resource data. [Type:Network Name]
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
…
…
2022-08-05T07:00:19.2931077-05:00 INFO  SmSql_<JOB ID#> PID=[XXXX] TID=[66]  Error when getting FCI resources:
2022-08-05T07:00:19.2931077-05:00 ERROR SmSql_<JOB ID#> PID=[XXXX] TID=[66] An error occurred while retrieving the cluster resources of type 'Network Name'
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
 
2022-08-05T07:00:19.2931077-05:00 DEBUG SmSql_<JOB ID#> PID=[XXXX] TID=[66] Check JobID [XXXXX] is marked  cancelled or not in DiscoverResource
2022-08-05T07:00:19.2931077-05:00 DEBUG SmSql_<JOB ID#> PID=[XXXX] TID=[66] Running JobID [XXXXX] is not mark cancelled in DiscoverResource
2022-08-05T07:00:19.3087320-05:00 DEBUG SmSql_<JOB ID#> PID=[XXXX] TID=[66] Start UpdateDiscoveryResults
2022-08-05T07:00:19.3087320-05:00 DEBUG SmSql_<JOB ID#> PID=[XXXX] TID=[66] UpdateDiscoveryResults Update SQL Instances and AGs with Operation Result
2022-08-05T07:00:19.3087320-05:00 DEBUG SmSql_<JOB ID#> PID=[XXXX] TID=[66] End UpdateDiscoveryResults
2022-08-05T07:00:19.3087320-05:00 DEBUG SmSql_<JOB ID#> PID=[XXXX] TID=[66] End DiscoverResource
2022-08-05T07:00:19.3087320-05:00 ERROR SmSql_<JOB ID#> PID=[XXXX] TID=[66] No SQL resource is discovered on the host. Check SQL resource(s) state on the host

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.