Tuesday, February 17, 2009

Error: 15457, Severity: 0, State: 1 un the RECONFIGURE statement to install

Error Message:
Error: 15457, Severity: 0, State: 1
Configuration option show advanced options changed from 1 to 1. Run the RECONFIGURE statement to install..

Root Cause:
Not running RECONFIGURE Statment after changing server options

This normally happens when we open Server Properties in Enterprise Manager and Click "OK" button instead of "Cancel" button in SQL 2000.

To prevent this error from being logged, always click Cancel button in the Properties windows incase you are not changing anything.

To confirm above statement follow below steps:

1. Open query analyser.
2. Run sp_cycle_errorlog command to recycle error logs.
3. Now run sp_readerrorlog and you will notice that error log has 10 lines.
4. Now open EM and perform above root cause.
5. Now again run sp_readerrorlog and you can notice this error message recorded.

No comments:

Post a Comment

Please do not spam!