2012年3月8日星期四

disappearing SQL reg. properties

When I try to see the properties of my sql registration it pops up and disappears immediately. Any one seen this before?
-KevinCheck under SQL error log for any kind of information.
And also try to lookup properties for that server from other machine.|||yes, the error log gives me some bogus message about recongigure (with override)

we tried it from another machine witht eh same error.|||WHat is the OS and SP level? (service pack)
And also for SQL server SP Level?

Try to post the brief message from error log.|||Windows 2000 sp3
sql 2000 standard edition sp3

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..

Error: 15457, Severity: 0, State: 1|||This error usually means that someone or something run sp_configure
without the RECONFIGURE statement. And this occurs if you change the property through enterprise manager.

In this case it looks like the 'show advanced options' was already set to 1 and something then tried to change it to 1 again. SQL Server then noted that the RECONFIGURE option was not used and therefore complained.|||that's why i said it was a bogus error.

ie. someone tried to change 1 to 1.

any other ideas?|||Is this behaviour is same when you tried from other machine?|||yes.

-k|||Then its better to reinstall SQL server, first uninstall and remove referenced registry keys for SQL server - reboot the box and reinstall freshly.

HTH|||Do you mean go into regedit to do this:

"remove referenced registry keys "

Won't the unistall do this for me. If not, what's the harm in leaving them there during the re-install.|||Its better to remove registry keys, to have clean install.

没有评论:

发表评论