- 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". It was fixed in Plesk Onyx 17.8 micro-update 10.
For Plesk Onyx 17.8, install the latest Plesk micro-updates .
For Plesk Onyx 17.5 and earlier Plesk versions, consider upgrading to the latest Plesk version .
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.