Competition: What’s your favorite Redgate tool? Enter now.
Login Failed for 'sa'
Apologies if this question has been posed previously, but I have a curious error that I need to rectify. We are using SQLBackup 6.2 on a SQL Server 2005 SP3 QA box. The backups have been failing for some time, and they are locking the 'sa' user. My concern is that RedGate should not be using 'sa' to log into the SQL Server, but I cannot find in the RG UI where to verify which account SQLBackup is actually using. Obviously it is sa, but I am not sure were to set it, or how it was set to use 'sa'. Previous forums explain to use sqbsetlogin to reset to Windows Auth. Is that still the case? Where can I verify the account to be used?
0 · Share on Twitter