NetWorker NMM 叢集例項的 SQL VDI 備份失敗。 找不到提供者。

當用戶端是叢集式 SQL Server 例項時，Microsoft使用 （NMM） NetWorker Module for Microsoft SQL Server 備份可能會失敗。  

典型的錯誤是
 

Cannot login to SQL Server --Provider cannot be found. It may not be properly installed.

例如： 

(pid=30180,2/25/2020 11:13:48 AM) D:/views/nw/19.2/nsr/db_apps/bsmsql/nsrsqlado.cpp(2261): Exiting GetProviderError().
(pid=30180,2/25/2020 11:13:48 AM) COM Error
(pid=30180,2/25/2020 11:13:48 AM) Code = 800a0e7a
(pid=30180,2/25/2020 11:13:48 AM) Code meaning = Unknown error 0x800A0E7A
(pid=30180,2/25/2020 11:13:48 AM) Source = ADODB.Connection

(pid=30180,2/25/2020 11:13:48 AM) Description = Provider cannot be found. It may not be properly installed.

(pid=30180,2/25/2020 11:13:48 AM) D:/views/nw/19.2/nsr/db_apps/bsmsql/nsrsqlado.cpp(1100): Exiting adoOpenConnection(), Exception.
66212 2/25/2020 11:13:48 AM  Cannot login to SQL Server VirtualSQLServerName\Instance01.

當 SQL Server 安裝期間發生問題，導致 Microsoft SQL Server 原生無法正確註冊時，可能會造成此問題。

例如，在

程式清單顯示了

Microsoft SQL Server Native Client 11.0 – 適用於 SQL Server 2012 和 2014

參考資料： 

https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/support-policies-for-sql-server-native-client?view=sql-server-ver15#support-lifecycle-exception注意 - 這僅適用於最高至 SQL Server 2017 的 SQL Server 版本。  
SQL Server Native Client 建議已在 SQL Server 2019 及更新版本中變更。

STEP 1.  Check registry  

Open Powershell on SQL Server and run,

Get-Childitem  "hklm:\software\microsoft\microsoft sql server"

RESULT:  
If you do not see a Key called "SQLNCL11"  then there is an issue with SQL Native Client.


STEP 2.   Connect to SQL instance using OLE DB Driver 

Open Powershell on SQL Server and run, 
 
$conn = New-Object System.data.oledb.oledbconnection
$conn.ConnectionString = "Provider=SQLNCLI11.1;OLE DB Services = -2;Server=VirtualServer\Instancename ;Trusted_Connection=Yes;"

##  where you will please replace   -  VirtualServer\Instancename  --  with  Actual Cluster server name and Instance name   

$conn.open() 

RESULT:
When Open contains no errors  then continue to next step. 
When Open fails then this confirms that there is a problem with SQL Native Client. 

$conn
$conn.close() 

To resolve this issue,

Run Start, Control Panel, Programs and Features, Uninstall Programs, 
you will see a version of,

Microsoft SQL Server 2012 Native Client 

Action:   Right click and select Repair.