- Plesk for Windows
Backup of remote database fails with following error:
PLESK_INFO: Unable to backup database content. Database admin_. Db server 203.0.113.2: [Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.]
The following error can be found in the Event Viewer of the remote MS SQL server:
CONFIG_TEXT: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided. [CLIENT: 203.0.113.1]
The solution from the following knowledge base article does not resolve the issue: Remote MS SQL backup failed
MSSQL admin password contains one or more of following symbols:
Plesk bug with ID PPPM-7863: "Failed to backup remote MSSQL database if special characters in SQL server admin password are used".
Admin password of the database can be modified:
- Navigate to Plesk > Tools & Settings > Database Servers > <Remote MS SQL instance>.
- Click on Change Password and specify the password without the special symbols.
- Click on Ok.