October 10, 2001 at 12:50 am
Hello,
after SP1 installation on SQL2k I can´t view properties of SQL server and Apps log contains this:
Error: 15457, Severity: 0, State: 1
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
After running RECONFIGURE nothing has changed. I didn´t find this error in any Technet...
Does anybody know, how to solve this problem?
Thanks
October 10, 2001 at 11:44 am
October 11, 2001 at 7:46 am
Yes, I can
October 11, 2001 at 8:15 am
Unless Steve has a better idea, I'd reboot first, see if that helps. If that fails, try uninstall/reinstall the sp. Have you looked in the error log?
Andy
October 11, 2001 at 8:48 am
I tried install/uninstall several times. Nothing has changed.
October 11, 2001 at 4:20 pm
Well, at a certain point it doesn't matter about the problem, only getting it fixed. I'd suggest uninstall, then manually remove all remaining files/folders associated plus clean out the registry keys, then try one more time. If you still can't resolve, either spring for the bucks to call MS support or just reformat. Sounds silly, but Im in favor of reformatting once in a while anyway, cleans up all the left over legacy stuff you acquire from installing/uninstalling stuff.
Andy
October 12, 2001 at 9:34 pm
Try the following (treat this like a REGEDIT hack as this can be dangerous)
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
Then try it again (set this back to 0 only if this works)
If that does not work run the following:
/* Config 518 is Show Advanced Options in sysconfigures table */
UPDATE sysconfigures
SET value = 0
WHERE config = 518
GO
RECONFIGURE WITH OVERRIDE
GO
Then imediately run the following:
sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO
Try it again, you may need to reboot.
Edited by - aplack on 10/12/2001 9:35:54 PM
October 16, 2001 at 5:48 pm
hey, just to add to this topic, I am experiencing the exact same problem (same error log generated, can't get into properties, etc...) on a test system that has been setup just to play with SQL. It took me a while to find some mention of it.
Just to keep everything straight, the system is W2K Server, SP2 plus a few security hotfixes for IIS, then SQL 2000 Standard Edition. I have no problem with accessing properties, etc. pre-SP1 but immedately after applying the SP the symptoms appear.
No amount of rebooting helps.
Weird. Good luck on finding an answer (your not alone!). Let us know if the fix mentioned by aplack worked for you, I'm going to try it in a day or two when I get a moment.
amra
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply