Login failed error on creating backups

Compresses, encrypts, secures and monitors SQL Server backups.

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

Login failed error on creating backups

Postby rre » Thu Feb 23, 2012 11:48 pm

I tried to backup a database with SQL Backup and receive always the error message "Login failed for user 'XYZ'. Reason: The account is disabled."
Thats absolutely true, but we don't know where we have to change the user in SQL Backup.

The SQLBackup Service is running with a windows account and the SQL Agent as well. But if want to start a backup with SQL Backup it tells us another user that will be used to create the backup.

Is there any other location where I can change permission or the user which is used to create a backup of a database?
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm

Postby rre » Fri Feb 24, 2012 6:14 pm

In this KB http://www.red-gate.com/supportcenter/Content/knowledgebase/SQL_Backup/KB200710000173 I see that a SQL Login has to be created.

It saids the following two things:

Create a SQL Server login that has the ability to backup (and restore) databases (y) by adding it to the SYSADMIN server

Install SQL Backup and set the service account to the domain account (x) then set the connection to the database to use the SQL Login (y).


How I can change this SQL Login later?
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm

Postby Brian Donahue » Fri Feb 24, 2012 7:06 pm

SQL Backup tries to impersonate the user doing the backup, so if you are connecting using SQL Backup Console and using Windows Authentication, all you should need to do is go into Active Directory and unlock your Windows domain account. If you connect using SQL Auth, I suspect the account management is done in SQL Server Management Studio somewhere.

SQL Backup doesn't have any facilities for managing accounts. (with one exception and that is when the SQL Backup Agent connects using SQL Authentication).
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby rre » Mon Feb 27, 2012 10:50 am

Basically we are using windows authentication for our SQL Backup Service and also for SQL Agent Service. Both accounts are activated and have rights to connect to the SQL Server instance.

Nevertheless, for creating backups a SQL account is used to create the backups. How can I change the SQL Account you mentioned?

For me it's no clear, how SQL Backup configured so that was still a SQL account is used.
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm

Postby Brian Donahue » Mon Feb 27, 2012 5:34 pm

I'll tell you about how to configure SQL Backup Agent to use SQL authentication, but I'm not sure that will help. You mention you use SQL authentication to do backups - is this the sql account you specify in the connection properties to SQL Backup? If so, we are talking about two different things.

The instructions for configuring the server components to use SQL authentication are here: http://www.red-gate.com/supportcenter/c ... urityModel
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby rre » Tue Feb 28, 2012 4:49 pm

Thanks, this solved my problem!
I changed the configuration for the server component to use windows authentication as it is describe in the support center and it works.

Thanks a lot!
rre
 
Posts: 30
Joined: Thu Jul 07, 2011 2:13 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests