- Plesk Onyx 17.5 for Windows
When importing MSSQL database dump in Plesk in Domains > example.com > Databases > example_db > Import Dump, the following error is shown:
PLESK_INFO: The dump of example_db was imported with errors.
Database user name is invalid. Only latin letters are allowed in the database user name
Despite the error, the database content is restored successfully.
The same database dump is restored successfully using SQL Server Management Studio.
IIS APPPOOL\ASP.NET v4.0 is missing from Microsoft SQL Server and his name is parsed as with
Connect to the server using RDP.
Open SQL Server Management Studio (or SSMS).
Note: If SSMS is not installed, the current version of SSMS can be found here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
Go to SQL_server_name > Security > Logins:
Right-click on Logins and select New Login...:
In the window Login - New, enter
IIS APPPOOL\ASP.NET v4.0to the field Login name and click OK to create the user: