Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".

Question

Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".

Raghavender Chavva

SSCrazy Eights

Points: 8669
More actions
November 6, 2015 at 1:15 am

#302155

Hi All,
I am trying to attach a database. But I am receiving below error:
Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".
I have added service accounts to administrator group.
I have provided full control to service account on the D drive and on the .mdf file also.
My self has full permissions on the drive and .mdf file, and I am in administrator group.
Restarted the SQL Server services.
Still same error.
Could you please help me in this issue.
Thank You.
Regards,
Raghavender Chavva
Thank You.
Regards,
Raghavender Chavva

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

Raghavender (11/6/2015)
Hi All,
I am trying to attach a database. But I am receiving below error:
Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".
I have added service accounts to administrator group.
I have provided full control to service account on the D drive and on the .mdf file also.
My self has full permissions on the drive and .mdf file, and I am in administrator group.
Restarted the SQL Server services.
Still same error.
Could you please help me in this issue.
Thank You.
Regards,
Raghavender Chavva

Quick thought, create a folder in the root of the drive and set the ownership of the folder to the sql server service credentials

😎

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

Raghavender (11/6/2015)
Hi All,
I am trying to attach a database. But I am receiving below error:
Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".
I have added service accounts to administrator group.
I have provided full control to service account on the D drive and on the .mdf file also.
My self has full permissions on the drive and .mdf file, and I am in administrator group.
Restarted the SQL Server services.
Still same error.
Could you please help me in this issue.
Thank You.
Regards,
Raghavender Chavva

put the file into a subfolder and grant the relevant NTFS permissions, this is the only supported and correct way to provide user access to the files

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 3

Still no use. Receiving the same error.

Thank You.

Regards,
Raghavender Chavva

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 4

VastSQL

SSC-Dedicated

Points: 36097

November 9, 2015 at 12:54 am

#1838476

You sure you are selecting the correct file?

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 5

Ratheesh.K.Nair (11/9/2015)
You sure you are selecting the correct file?

Yes Ratheesh..

Thank You.

Regards,
Raghavender Chavva

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 6

VastSQL

SSC-Dedicated

Points: 36097

November 9, 2015 at 2:19 am

#1838484

Can you see Lock Icon on those files?

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 7

I could not see any locks on those files.

Thank You.

Regards,
Raghavender Chavva

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 8

Any other instance running on that server?

The file be held by some other process. Hope you have already tried keeping the file in other sub-directory or another drives.

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 9

Only one instance is running and we have made separate directory for that file.

We tried by moving the mdf and ldf files to different drives.

But no luck.

Thank You.

Regards,
Raghavender Chavva

Ant-Green SSC Guru Points: 113507 More actions · Answer 10

have you set the necessary permissions to the folders?

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 11

Are you able to connect to instance without any issue??

Try running SSMS as administrator. Also check what error you get while using query sp_attach_db.

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 12

Ratheesh.K.Nair (11/9/2015)
Are you able to connect to instance without any issue??
Try running SSMS as administrator. Also check what error you get while using query sp_attach_db.

Yes, able to connect the instance without any issues.

Also tried by Running SSMS as administrator. No Luck.

I have tried all the possible options I can, but no use. Not sure where the blocking is.

have you set the necessary permissions to the folders?

Anthony,

We have full control on those folders and files.

We are added in admin group on that box.

Thank You.

Regards,
Raghavender Chavva

Ant-Green SSC Guru Points: 113507 More actions · Answer 13

Its not you / the admin that needs rights its the service account running SQL.

You can have all the rights you want/need, if SQL can't access the file you can't get the file into SQL

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 14

anthony.green (11/9/2015)
Its not you / the admin that needs rights its the service account running SQL.
You can have all the rights you want/need, if SQL can't access the file you can't get the file into SQL

Yes Even service accounts are added into admin group and we have given full control on the folder and files.

Thank You.

Regards,
Raghavender Chavva