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