Access permissions to DATA folder contents

• jjdonn

  SSC Enthusiast

  Points: 174

  More actions

  July 18, 2020 at 3:29 am

  #3771026

  I am trying to get file access to copy mdf file from DATA folder on dead computer.  I am able to mount the HDD successfully as an external drive on another computer but despite being admin with full permissions am unable to get inside of sql server 2012 DATA folder.  Error message says I do not have read permission.   Same issue on newly installed 2012 instance freshly installed on new computer where I want to copy to.    How can I get access?

• Jeffrey Williams

  SSC Guru

  Points: 90348

  More actions

  July 18, 2020 at 4:16 pm

  #3771081

  Have you tried taking ownership of the folder - and enabling inheritance?

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs

• jjdonn

  SSC Enthusiast

  Points: 174

  More actions

  July 18, 2020 at 10:58 pm

  #3771104

  PS D:\program files\Microsoft SQL Server-2\MSSQL11.ROMEXIS\MSSQL\DATA> get-acl .\Romexis_db.mdf | FL

  Path   : Microsoft.PowerShell.Core\FileSystem::D:\program files\Microsoft SQL

  Server-2\MSSQL11.ROMEXIS\MSSQL\DATA\Romexis_db.mdf

  Owner  : BUILTIN\Administrators

  Group  : OFFICE-PC3\jack

  Access : BUILTIN\Administrators Allow  FullControl

  NT AUTHORITY\SYSTEM Allow  FullControl

  NT SERVICE\MSSQL$ROMEXIS Allow  FullControl

  Audit  :

  Sddl   : O:BAG:S-1-5-21-2033574492-82274976-293738974-1006D:AI(A;ID;FA;;;BA)(A;ID;FA;;;SY)(A;ID;FA;;;S-1-5-80-139646859

  8-75167229-630969873-3559538447-1635215798)

   

  CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'D:\Program Files\Microsoft SQL Server-2\MSSQL11.ROMEXIS\MSSQL\DATA\Romexis_db.mdf'. (.Net SqlClient Data Provider)

  Attachments:

  You must be logged in to view attached files.

• jjdonn

  SSC Enthusiast

  Points: 174

  More actions

  July 18, 2020 at 10:59 pm

  #3771106

  Won't let me change owner.   See attached png for error.  MSSMS cant attach mdf (access error ....);

  Attachments:

  You must be logged in to view attached files.

• Jeffrey Williams

  SSC Guru

  Points: 90348

  More actions

  July 19, 2020 at 2:52 pm

  #3771150

  This isn't a SQL Server issue - looks like you have some Windows issues on that system.

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs

• pietlinden

  SSC Guru

  Points: 63578

  More actions

  July 19, 2020 at 8:23 pm

  #3771167

  Did you try running SSMS as admin, too?