Restore of database fails with ‘5(Access is denied)’

Posted on

Question :

I am trying to restore database from another server, but I keep getting this error. I have tried changing security settings (giving permission) but still it keeps giving me this. Anybody have a clue how to fix this?
enter image description here

Answer :

It seems that the user doesn’t have permission to the location in which you are trying to restore the database. Please try to restore the database in another drive other than C or grant access to the user ,under which sql server is running, permission to the drive.

Just found another post with same problem. Please have a look:
mssql ‘5 (Access is denied.)’ error during restoring database

You could try starting SSMS in administrative mode and trying it again.

Leave a Reply

Your email address will not be published. Required fields are marked *