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.
2012年3月8日星期四
disappearing SQL reg. properties
标签:
database,
disappearing,
disappears,
immediately,
microsoft,
mysql,
oracle,
pops,
properties,
reg,
registration,
server,
sql
订阅:
博文评论 (Atom)
没有评论:
发表评论