Not able to Restore, Error 890: RESTORE DATABASE permission denied for database:

Sanjib

Not able to Restore the full or log file and getting the below error

 

8/30/2024 2:23:55 PM: Error 890: RESTORE DATABASE permission denied for database:  (us_pinnacle_multi_replica)

8/30/2024 2:23:55 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal  does not exist, its corresponding server principal does not have server access, this type of database principal cannot 

 be impersonated, or you do not have permission.

Kurt_M

Hi @Sanjib

For this issue, the error 890 from SQL Backup is explained through the error log, but the subsequent SQL error 15157 seems like the principal or login being referenced either doesn't exist or doesn't have the necessary permissions to complete the restore operation. You'll need to check the user permissions on the target database and ensure that the correct login is being used.