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?
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.