Backup failed on disabled sql login.

Forum for users of Redgate's SQL Backup tool

Backup failed on disabled sql login.

Postby dklein9930 » Wed Jan 02, 2013 4:45 pm

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
 
Posts: 13
Joined: Wed Mar 02, 2011 3:27 pm

Postby petey » Wed Jan 02, 2013 5:02 pm

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.

Code: Select all
EXEC master..sqbsetlogin '<login>', '<password>'

To revert to using the SQL Backup Agent service startup account, use sqbsetlogin with empty parameters e.g.

Code: Select all
EXEC master..sqbsetlogin ', ''
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2296
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron