Error "Ad hoc update to system catalogs is not supported" while installing MDB for 14.1

Document ID : KB000031442
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

I tried to install USRD 14.1. The creation of the MDB (SQL Server) failed with the following error which can be found in the install_mdb.log file:

Msg 5808, Level 16, State 1, >Server Name>\INSTANCE, Line 1 

Ad hoc update to system catalogs is not supported. 
07-10,14:51:24 Failed to create the database (errorlevel=1) 
07-10,14:51:24 Setupmdb_pre exit /B return code=400 
07-10,14:51:24 Pre-process failed (errorlevel=400) 
07-10,14:51:24 Setupmdb exit /B return code=110 

Environment:  

CA Service Desk Manager 14.1

 

Answer: 

The problem is due to the fact to have 'allow_updates' set to 1 on SQL Server. 

To verify that, please run the following query directly on the SQL Server: 

sp_configure "Allow Updates" 

and verify the value in 'config_value' column; if it is 1, please run the following query: 

sp_configure allow_updates,0 
RECONFIGURE 

and then try again to install the mdb.