Backup failed on disabled sql login.

dklein9930

Greetings,

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

petey

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 ', ''