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.