Comments
1 comment
-
By default, SQL Backup uses the SQL Backup Agent service startup account to perform all backups and restores. If you require SQL Backup to use a SQL login to perform the operations, you use the sqbsetlogin extended stored procedure to specify the login and password e.g.
EXEC master..sqbsetlogin '<login>', '<password>'
To revert to using the SQL Backup Agent service startup account, use sqbsetlogin with empty parameters e.g.EXEC master..sqbsetlogin ', ''
Add comment
Please sign in to leave a comment.
I recently disabled an old sql login, used by a former employee, now a database backup is failing with the following message:
SQL error 18470: Login failed for user ''. Reason: The account is disabled.
Where is redgate using this account, as it is not specified in the backup script? And, how can I switch this user account out for a domain service account?
Thanks,
DK