Backup failed on disabled sql login.

dklein9930dklein9930 Posts: 20
edited January 2, 2013 11:02AM in SQL Backup Previous Versions
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

Comments

  • peteypetey Posts: 2,358 New member
    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 ', ''
    
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.