August 4, 2019 at 11:50 am
Hi,
From Veeam we are taking SQL Server backup. we are using ABC\abcadmin credentias to take the backup. We got a below warning.
Warning: [TDB]Unable to update SQL backupset for instance : Code = 0x80040e09 Code meaning = IDispatch error #3081 Source = Microsoft OLE DB Provider for SQL Server Description = The UPDATE permission was denied on the object ‘backupset’, database ‘msdb’, schema ‘dbo’.
I opened the respective SQL Server. Checked whether the user is exist or not in the SQL Server.. In the SQL Logins i found that "ABC\Domainusers" exist. what ever the configured ABC\abcadmin is under Domain users.
i tried below commands from google.
alter login [ABC\Domainusers] enable
thrown the error : cannot use alter login with enable or disable argument for a windows group.grant or revoke the connect sql permission.
I tried adding ABC\Domainusers to sysadmin role. throwing the error cannot alter the server role 'sysadmin' because it does not exist or you do not have permission.(error :15151)
How to resolve the issue? Please help.
Thanks,
Jo
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy