Frequently Asked Questions
Frequently Asked Questions: M-Files Server Administrator
If MS SQL Server Express 2012 fails to create a new document vault..
Posted by Timo Lahti (M-Files) on 22 January 2013 12:40 PM

Applies to:

  • M-Files 9
  • Microsoft SQL Server Express 2012

 

Symptoms:

It is possible, that the freshly installed Microsoft SQL Server 2012 Express edition causes an error message appear

when the administrator tries to create a new document vault, hosted with the SQL Server engine:

 

MPropertyPage2.cpp, 102, Creating a database for the store failed. (0x8004044F)
MPropertySheet2.cpp, 143, Creating a database for the store failed. (0x8004044F)
PropertySheetDocumentVault.cpp, 353, Creating a database for the store failed. (0x8004044F)
RPCVaultsAdmin.cpp, 170, Creating a database for the store failed. (0x8004044F)
VaultManager.cpp, 727, Creating a database for the store failed. (0x8004044F)
VaultManager.cpp, 807, Creating a database for the store failed. (0x8004044F)
Vault.cpp, 2447, Creating a database for the store failed. (0x8004044F)
CreateVault.cpp, 100, Creating a database for the store failed. (0x8004044F)
CreateVault.cpp, 161, Creating a database for the store failed. (0x8004044F)
CreateVault.cpp, 161, Ad hoc update to system catalogs is not supported. (ERROR: 5808, SQLSTATE: 42000) (0x80040E14)
MSSQLServerServices.cpp, 448, Ad hoc update to system catalogs is not supported. (ERROR: 5808, SQLSTATE: 42000) (0x80040E14)
MSSQLServerServices.cpp, 552, Ad hoc update to system catalogs is not supported. (ERROR: 5808, SQLSTATE: 42000) (0x80040E14)
MSSQLServerServices.cpp, 190, Ad hoc update to system catalogs is not supported. (ERROR: 5808, SQLSTATE: 42000) (0x80040E14)
MSSQLServerServices.cpp, 219, Ad hoc update to system catalogs is not supported. (ERROR: 5808, SQLSTATE: 42000) (0x80040E14)
MSSQLServerServices.cpp, 223, Ad hoc update to system catalogs is not supported. (ERROR: 5808, SQLSTATE: 42000) (0x80040E14)
SQLHelper.cpp, 2821, Ad hoc update to system catalogs is not supported. (ERROR: 5808, SQLSTATE: 42000) (0x80040E14)
(M-Files 9.0.3372.6)

 

Resolution:

The MS SQL Server 2012 Express is a supported platform, and it has been successfully passed our tests. 

Please try to logon to the SQL Server with sysadmin rights, and execute the following commands with for example with MS SQL Server Management Studio:

sp_configure 'allow updates',0;
reconfigure with override;

After this, the document vault creation should work.

If there's any need for additional information, please contact M-Files Customer Support by the contact form: http://support.m-files.com -> submit a ticket. 

 

(3 vote(s))
This article was helpful
This article was not helpful

Help Desk Software by Kayako case