SCSQL verification failing with OS error: 5(Access is denied.)

Applies to

• SnapCenter Server (SC)
• SnapCenter Plug-in for Microsoft SQL Server (SCSQL)

Issue

• Remote verification with SCSQL is failing with the following alert seen in the Event logs:

Alert: MSSQL on Windows: Failed to open primary database file
Source: mssql_server\MSSQLSERVER
 Path: Not Present
 Last modified by: System
 Last modified time: 2023-06-19 16:06:54
 Alert description: Event ID: 17204. FCB::Open failed: Could not open file C:\scmnpt\<disk_path>.ldf for file number 0.  OS error: 5(Access is denied.).

• SCSQL job log shows error:

ERROR SmSql_800 PID=[2616] TID=[38] Page (1:10) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED   0_PCT_FULL'.
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object ID 99)' (object ID 99).
CHECKDB found 1 allocation errors and 0 consistency errors in database '__Verification__XXXXXXXX-XXXX-XXXX-XXXXXXXXXXXX'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (__Verification _ _ XXXXXXXX-XXXX-XXXX-XXXXXXXXXXXX).
ERROR SmSql_800 PID=[2616] TID=[38] An exception occurred while executing a Transact-SQL statement or batch.

• The username is valid and has the correct permissions:

  DEBUG SmSql_800673 PID=[2616] TID=[38] verifying backup of database: [instance\database]
DEBUG SmSql_800673 PID=[2616] TID=[38] Using host auth [domain\instance] to connect to SQL instance: [instance_name]
DEBUG SmSql_800673 PID=[2616] TID=[38] Connecting to SQL Server: [server_name]
DEBUG SmSql_800673 PID=[2616] TID=[38] Host auth is valid, and it has sysadmin privileges.