SQL error 15123 occurs while changing or viewing the values of any advanced server configuration option.
Here at Ibmi Media, as part of our Server Management Services, we regularly help our Customers to resolve SQL related errors.
In this context, we shall look into the causes of this SQL issue and how to tackle it.
Nature of SQL error 15123?
There are a lot of server-level configurations that we can view or make any changes using the command sp_configure. However, the advanced options cannot be viewed or changed if the value of "show advanced options" is set to 0 or disabled.
Running the sp_configure command we can view the value of "show advanced options". In case, if the value of this command returns as zero then it means that the "show advanced options" is disabled.
As a result, this is the main reason for receiving the 15123 error while changing any advanced server-level parameters.
Here is the complete error message:
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option does not exist, or it may be an advanced option.
Steps to fix SQL error 15123 ?
As earlier stated, if the value of “show advanced options” is set to zero and disabled then this error occurs as we can't make any changes to advanced server options.
Therefore, in order to fix this error, we need to set its value to 1 and enable it. For that, execute the following command;
exec sp_configure ‘show advanced options’, 1
RECONFIGURE WITH OVERRIDE
After enabling the advanced server options, we can run the command sp_configure to view the existing values of advanced options. Also, we can use the same command to make any changes to advanced options.