How can we help you today? How can we help you today?

Backup failed on disabled sql login.

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
dklein9930
0

Comments

1 comment

Sort by
  • 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 ', ''
    petey
    0

Add comment

Please sign in to leave a comment.