1

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

1
  • Each SQL Server instance has its own (default) data folder. Is the C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA folder actually owned by the instance you're trying to restore the backup to? Likely that's the folder path of the server from which the backup originates and you'll need to specify new file paths for the data and log files in your RESTORE DATABASE command. See: Restoring a database and move files for an example. Nov 27, 2021 at 8:59

2 Answers 2

0

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

0
0

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

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy