SQL error 15123 occurs while changing or viewing the values of any advanced server configuration option.

Here at Bobcares, we have seen several such SQL related issues as part of our Server Management Services for web hosts and online service providers.

Today we’ll take a look at the cause for this error and see how to fix it.

Why does SQL error 15123 occur

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.
~~

How we fix SQL error 15123

Now let’s see how our Support Engineers resolve this error to our customers.

As we discussed above, 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. So in order to fix this error, we need to set its value to 1 and enable it. For that, we run the below 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.

[Need any further assistance in fixing SQL errors? – We’re available 24*7]

Conclusion

In short, this error arises while changing or viewing the values of any advanced server configuration option. Today, we saw how our Support Engineers fix this SQL error.