Parallels

Symptoms

 If data location of MSSQL databases has been changed to a different server instead of the original one,  Plesk is uable to create new web applications. The action fails with the error:

Error: Package installation failed Error occurs during script performing. Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\08c43cec-3c35-4359-936a-9399d23008ac.mdf' may be incorrect.

CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.

Cause

When Plesk creates new application that uses MSSQL database, it determines the current MSSQL databases location by sending a request to MSSQL server

select filename from master.dbo.sysdatabases where name = 'master'

The answer is processed by Plesk, and Plesk should point to the real database location. If it’s not, the records in MSSQL server need updating as per the solution below:

Resolution

Update information in table master.dbo.sysdatabases manually according to example below:

Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to i



Configuration option 'allow updates' changed from 0 to 0. Run the RECONFIGURE statement to install.