Comments
Sort by recent activity
Hi Brian,
It has recorded the backup and the error message in the GUI. It shows the correct account attempting the backup 'CORP\sqlsrv', which is the service account that SQL Backup uses.
Regards
Stephen / comments
Hi Brian,
It has recorded the backup and the error message in the GUI. It shows the correct account attempting the backup 'CORP\sqlsrv', which is the service account that SQL Backup uses.
Regards
S...
that I have not been able to resolve this, and wonder whether there is a configuration change I need to make? / comments
that I have not been able to resolve this, and wonder whether there is a configuration change I need to make?
Hi Brian,
The account that is used by the SQL Backup service, the SQL Agent service, and the SQL Server service is the same one (in our case 'CORP\sqlsrv'). It has system administrator server role permissions to all databases by default.
I have tried getting the SQL Backup Agent to log in using SQL Server authentication by using:
sp_addextendedproc sqbsetlogin, 'xp_sqlbackup.dll'
GO
sqbsetlogin 'sa', 'sqbpassword'
GO
sp_dropextendedproc sqbsetlogin
GO
This did not resolve the issue.
I tried this:
I create two databases. One called SQLBackpTest, and another SQLBackpTest2.
SQLBackpTest has a collation of SQL_Latin1_General_CP1_CI_AS
SQLBackpTest2 has a collation of Latin1_General_CI_AS.
The server collation is Latin1_General_CI_AS.
A scheduled backup of SQLBackpTest fails with Error 880: BACKUP DATABASE permission denied. A scheduled backup of SQLBackpTest2 succeeds.
Regards
Stephen / comments
Hi Brian,
The account that is used by the SQL Backup service, the SQL Agent service, and the SQL Server service is the same one (in our case 'CORP\sqlsrv'). It has system administrator server role ...