SQL Backup Fails User 'guest' does not have permission

[MDLBT]

Hi,

SQL backups have been failing on 2 BE2012 servers recently with the same error message:

V-79-57344-65088 - WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cann... User 'guest' does not have permission to run DBCC checkdb for database 'master'. V-79-57344-65088 - WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cann... User 'guest' does not have permission to run DBCC checkdb for database 'msdb'.

I have completed the steps suggested in the below links, specifically making sure the account used to access the DB has sysadmin and usermapping rights assigned but the error still comes back.

https://www-secure.symantec.com/connect/forums/numerous-dbcc-errors

http://www.symantec.com/docs/TECH69132

http://www.symantec.com/docs/TECH144230

Any additional suggestions appreciated,

[lmosla]

Under services check to make sure the SQL Server (BackupExec) service is running under the Local System account. 

[VJware]

Edit the backup job and then choose to edit/test credentials. Change the credentials to the 'sa' account directly and check if the backup with dbcc check completes successfully or not.

If it does, re-verify the BE account (which is selected against the SQL resource in the backup job - edit/test credentials) was given appopriate SQL permissions and restart the SQL services 7 the remote agent service on the SQL server for the changes to take effect.

[MDLBT]

Thanks for the reply,

SQL Server (BAckupExec) is already running as a Local System Account.

[MDLBT]

Hi,

Thanks for the suggestion. I can create an account with any name (sa, fd, lt) and it is successful when i test the credentials on it, I set it to sa and ran the backup and it failed with the same error message unfortunately.

I see the sa account appears to be disabled on the SQL database BackupExec and I cant enable it, im assuming this is by design.  Backup fails on the other SQL database irrespective of that though.

[VJware]

Do you receive the same error message when the 'sa' account is used ? i.e. the user 'sa' does not  permissions ?

[MDLBT]

Hi,

it never references the account actually used for the backup, it only refers to 'guest':

User 'guest' does not have permission to run DBCC checkdb for database master                                               

This is the same whichever account you use to run the SQL backup.

.

[VJware]

Try this KB article - https://support.microsoft.com/en-us/kb/2268122