Skip to main content
NetApp Knowledge Base

SCSQL verification is unable to open physical file

  1. Last updated
  2. Save as PDF
Views:
252
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
 

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.