- Plesk Onyx for Windows
Cannot create a new database for MS SQL server in Plesk:
PLESK_INFO: Create new database failed: mssqlmng failed: The file "C:\Program Files (x86)\Plesk\Databases\MSSQL\MSSQL12.MSSQLSERVER2014\MSSQL\DATA\filename.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. at (VADOConnection::execute line 78) at execute console command --create-database(vconsoleapp::start line 122) at execute "C:\Program Files (x86)\Plesk\admin\bin\mssqlmng" --create-database "--server=.\MSSQLSERVER2014" "--login=sa" "--password=*" "--database=databasename"(vconsoleapp::run line 139) (Error code 1)
MSSQL installation directory is compressed (files and folders shown in blue):
MSSQL does not work with compressed files.
Connect to the server via RDP;
Disable compression on the Plesk folder by unchecking the option marked on the screenshot (right side):
- Create database.