Cannot access path when attaching database when data files on SMB share

• keymoo

  SSCrazy

  Points: 2975

  More actions

  October 1, 2014 at 2:31 am

  #297049

  I have a Windows Server 2012 R2 2 node cluster with SQL Server 2014 FCI installed. Data files are on a separate Windows Server 2012 R2 file server. Data files share has been permissioned to the SQL Server service and SQL Server Agent service accounts as Full Control. NTFS Permissions are Full Control.

  When I try to attach a database

  CREATE DATABASE AdventureWorksDW2012

  ON (FILENAME = '\\apricot\mssql_VIOLET\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorksDW2012_Data.mdf')

  FOR ATTACH

  I get this error:

  Msg 5120, Level 16, State 101, Line 4

  Unable to open the physical file "\\apricot\mssql_VIOLET\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorksDW2012_Data.mdf". Operating system error 5: "5(Access is denied.)".

  If I log into the file server (called APRICOT) and look at the NTFS permissions they all look good. I have also reapplied the NTFS permissions from the root folder down.

  EDIT

  If I log on to one of the nodes in the cluster as the SQL Server service account and navigate to \\apricot\mssql_VIOLET\MSSQL12.MSSQLSERVER\MSSQL\DATA and copy and paste the data file, it works fine.

  EDIT2:

  If I log on to the file server and Enable Inheritance at the root level, then Replace all child objects with inheritable permission entries from this object, I get this error:

  

  User Account Control settings on all nodes and the file server are set to Never notify