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%\\""
sandbox_mssql_server_db_server_network_backup_dir \\\\22.214.171.124.\\d$\ emp
sandbox_mssql_server_db_server_temp_backup_dir d:\ emp
- 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.