Sandbox DB server has been registered properly in the system according to guide.
But when attempt to create a DB via
cmd the error appears:
& '"%plesk_bin%"\database.exe' --create cnolanDB -domain example.com -server 18.104.22.168 -print-id... database.exe : Unable to create database: No such database server registered in Plesk At line:1 char:1 + & 'C:\Program Files (x86)\Parallels\Plesk\admin\bin\database.exe' --create... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (Unable to creat...stered in Plesk:String) , RemoteException + FullyQualifiedErrorId : NativeCommandError
It doesn't show up in the Plesk panel so it would seem the CLI is our only option for adding the database through Plesk.
How to make sure sandbox DB server is properly installed? How to create database and make it available in Plesk?
There are few points bellow about sandbox DB server for Plesk that should be noted:
If the sandbox server was configured - this means it was configured properly. Otherwise it shows error on registration step.
To make sure settings are implemented you can check the details in database:
"%plesk_bin%"\dbclient.exe --direct-sql --sql="select * from misc where param like \"sandbox%\"" param val sandbox_mssql_server_admin sa sandbox_mssql_server_db_server_network_backup_dir \\22.214.171.124.\d$\temp sandbox_mssql_server_db_server_network_backup_pwd $AES-128-CBC$c...k+yMUk1I9w sandbox_mssql_server_db_server_network_backup_usr 126.96.36.199\example sandbox_mssql_server_db_server_temp_backup_dir d:\temp sandbox_mssql_server_host 188.8.131.52\MSSQLSERVER2012 sandbox_mssql_server_passwd $AES-128-CBC$c...kdfdkAAsdw
- The Sandbox server if configured is never used during database creation neither from GUI nor from CLI.
- The sandbox server is not supposed to be used for hosting customers database or even be listed in the list of the configured databases servers. The Sandbox server feature is designed to use intermediate temporary server connected with "sysadmin" role to fix customers' database dumps is being restored on MSSQL servers connected with user without sysadmin role.