reconfigure error : Ad hoc update to system catalogs is not supported.

If you are working as a SQL Developer or especially a SQL Server Database Administrator (DBA), you must have updated the database instance configuration options using sp_configure on MS SQL Server databases frequently.

Recently I was again working on a Microsoft SQL Server 2005 database and updating the database configuration options using sp_configure.
I got the following error message :

Ad hoc update to system catalogs is not supported.

This ad hoc update error is not a common sql engine error during the use of sp_configure and reconfigure system sql procedures.

Here is the exact t-sql script batch I run on the MS SQL Server 2005 :

This changes the config_value of the remote admin connections option from 0 to 1 .
I'm trying to update this sql server configuration option in order to let remote connections for remote Dedicated Administrator Connection .

The output is :
Configuration option 'remote admin connections' changed from 0 to 1. Run the RECONFIGURE statement to install.

So far so good.
But when I execute the below reconfigure statement,

I got the following sql server error :

Msg 5808, Level 16, State 1, Line 1
Ad hoc update to system catalogs is not supported.

In order to solve this problem (Ad hoc update to system catalogs is not supported reconfigure error), I forced the reconfigure statement with Override option as seen in the below sql command.

And this reconfigure with override command runs successfully which modifies the remote admin connections configuration option run_value from 0 to 1.

One reason for this error is SQL Server configuration parameter allow updates to be set to "1".
When allow updates sp_configure option is set to 1, SQL developers can experience the "Ad hoc update to system catalogs is not supported" error message.
Setting the SQL Server configuration parameter or configuring sp_configure allow updates option to "0" can solve the problem.