Backup failed on disabled sql login.

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

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: 2234
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests