SCSQL验证无法打开物理文件
适用场景
适用于 SQL 的 SnapCenter 插件( SCSQL )
问题描述
SnapCenter尝试运行数据库验证、但SmSql_JOB.log中生成以下错误
2021-02-03T03:13:11.7885267-07:00 DEBUG SmSql_2241 PID=[10676] TID=[14] Connecting to SQL Server: [SERVER_NAME]
2021-02-03T03:13:13.2906593-07:00 DEBUG SmSql_2241 PID=[10676] TID=[14] Attaching database: [__Verification__##########-####-####-####-##########]
2021-02-03T03:13:13.6616001-07:00 ERROR SmSql_2241 PID=[10676] TID=[14] Unable to open the physical file "C:\scmnpt\mpdisk0000\DATABASE.mdf". Operating system error 5: "5(Access is denied.)".
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
2021-02-03T03:13:13.6636015-07:00 DEBUG SmSql_2241 PID=[10676] TID=[14] Failure HResult: -2146233088
2021-02-03T03:13:13.6656026-07:00 DEBUG SmSql_2241 PID=[10676] TID=[14] Setting file permissions and trying to attach again...
2021-02-03T03:13:13.6826802-07:00 DEBUG SmSql_2241 PID=[10676] TID=[14] .ctor