Verification across SQL Instances not possible
Applies to
SnapCenter Plug-In for Microsoft SQL (SCSQL) 4.3.1
Issue
When SCSQL scheduled verification job of multiple instances runs, it will randomly choose only one of the SQL instances configured to perform the verification.
When Instance A needs to run the verification of Instance B,
access denied
errors are reported.SnapCenter Job Log:
ERROR SmSql_PID=[] TID=[] Unable to open the physical file "C:\scmnpt\mpdisk0001\\".
Operating system error 5: "5(Access is denied.)".
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Error,,MSSQL$_,"FCB::Open failed: Could not open file C:\scmnpt\mpdisk0001\\ for file number 0.
OS error: 5(Access is denied.)."