How can we help you today? How can we help you today?

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

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.
Sanjib
0

Comments

1 comment

Sort by
  • 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.
    Kurt_M
    0

Add comment

Please sign in to leave a comment.