This problem occurred when I was running the RECONFIGURE along with the "show advanced options and database mail xps" option through the sp_CONFIGURE to enable SQL Server Database Mail in SQL Server 2012. I got the following error. See the screenshot below.
Note - By default, SQL Server does not allow such ad-hoc updates to the system catalogs.
Solution - To resolve this issue, you have two options in SQL server
Option 1: you can use the "WITH OVERRIDE" option of the RECONFIGURE command and at this time it will be successful. See the screenshot below.
Option 2: Use this stored procedure sp_configure 'allow updates', 0
First, check the column- config_value of the "allow updates" configuration option. If it’s set to 1, change this value to 0, which is the default value,
Now, change the column -config_value value 1 to 0. See the screenshot below,
The problem has been resolved. You can see the screenshot given below,