SCSQL验证失败、并显示操作系统错误：5 (访问被拒绝。)

适用场景

• SnapCenter 服务器（ SC ）
• 适用于 Microsoft SQL Server 的 SnapCenter 插件（ SCSQL ）

问题描述

• 使用SCSQL进行远程验证失败、并在事件日志中显示以下警报：

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.).

• 此用户名有效且具有正确的权限：

  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.