Red Gate forums :: View topic - Login failed error on creating backups
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Login failed error on creating backups

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rre



Joined: 07 Jul 2011
Posts: 29

PostPosted: Thu Feb 23, 2012 11:48 pm    Post subject: Login failed error on creating backups Reply with quote

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?
Back to top
View user's profile Send private message
rre



Joined: 07 Jul 2011
Posts: 29

PostPosted: Fri Feb 24, 2012 6:14 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Fri Feb 24, 2012 7:06 pm    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
rre



Joined: 07 Jul 2011
Posts: 29

PostPosted: Mon Feb 27, 2012 10:50 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Feb 27, 2012 5:34 pm    Post subject: Reply with quote

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/content/SQL_Backup/help/6.5/SBU_SecurityModel
Back to top
View user's profile Send private message
rre



Joined: 07 Jul 2011
Posts: 29

PostPosted: Tue Feb 28, 2012 4:49 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group