var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: 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?
Check 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?
Then its better to reinstall SQL server, first uninstall and remove referenced registry keys for SQL server - reboot the box and reinstall freshly.
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.