Article ID: 1654, created on Oct 6, 2008, last review on May 10, 2014

  • Applies to:
  • Plesk 8.2 for Windows
  • Plesk 8.1 for Windows

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:

sp_configure 'allow updates', 1
GO


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

RECONFIGURE WITH OVERRIDE
GO
update master.dbo.sysdatabases set filename='E:\MSSQL\master.mdf' where name = 'master'
GO
sp_configure 'allow updates', 0
GO


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

RECONFIGURE WITH OVERRIDE
GO

7000fbc03a7e92b93bc676a7c04a4ce6 b23c51a6195823476e308cc12db2be0e 85a92ca67f2200d36506862eaa6ed6b8 a914db3fdc7a53ddcfd1b2db8f5a1b9c c45acecf540ecd42a4bbfb242ce02b1d 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF