Login failed for user when connecting to server

1

I use SQLBackupAndFTP to do a daily back-up of a single database. The Backup Job has been working for a year, but has recently stopped working.
The error message is:
Login failed for user
‘MicrosoftAccount[my email address]’
The account is disabled.

I’ve checked my MS account and it’s active and working. How can I solve this problem?
Thank you!

2

Hello Emma,

Thank you for your message.

The error message:

“Login failed for user ‘MicrosoftAccount\*******@outlook.com’. Reason: The account is disabled.”

is returned by Windows/SQL Server, not by SQLBackupAndFTP. Unfortunately, this means we are unable to control or override this behavior from our side.

I recommend the following steps:

  • Please verify your credentials and try specifying the username with and without the domain.
  • Make sure you can connect to the SQL Server using the same credentials via SQL Server Management Studio.

Once the connection works in SSMS, it should also work in SQLBackupAndFTP.