Skip to main content
NetApp Knowledge Base

SCSQL verification is unable to open physical file

Views:
81
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

SnapCenter Plug-In for SQL (SCSQL)

Issue

SnapCenter attempts to run database verification but the below error is generated in the 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

 

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support