May 31, 2018 at 6:55 pm
Hi all,
I have a really strange problem that has just started to occur. I am trying to take a backup of an existing database(in fact any database under the current instance) and I am getting the error as per below:
backup database jam to disk = 'd:\temp\jam.bak'
Msg 15247, Level 16, State 15, Line 1
User does not have permission to perform this action.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
The user "jam" has SYSADM access, as well as having Windows level file permissions to the d:\temp folder.
I get similar error via setting it up as a schedule under "Maintenance Plans":
Executing the query "BACKUP DATABASE [jam] TO DISK = N'D:\\MSSQL_B..." failed with the following error: "User does not have permission to perform this action.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I have tried the following:
- Created a new SQLServer user with SYSADM permissions and logging in as that user, to no avail.
- Created a new database(no issues there), but can't back it up using the same user. Same permissions error
- Added the user to the database and gave user access to role "db_backupoperator" and "db_owner" to no avail
- Rebooted the server
- Tried using different users that have SYSADM access
It's a strange one. Any ideas?
May 31, 2018 at 7:10 pm
Sorry to hassle. I worked it out.
I was playing around with Audits and Audit specifications a few days ago and had an audit action type on "Backup_Restore_Group" and on the audit, to fail the operation. Silly me!
It's a bit of a Gotcha though.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply