- Plesk for Windows
Note: This article has the reference to the issue with the fix available:
- #PPPM-7863 "Support issue #PPPM-7863"
- Plesk Onyx 17.8 Release 17 April 2018
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.
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.