Results 1 to 12 of 12
  1. #1
    Join Date
    May 2002
    Posts
    47

    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?

    -Kevin

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check under SQL error log for any kind of information.
    And also try to lookup properties for that server from other machine.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2002
    Posts
    47
    yes, the error log gives me some bogus message about recongigure (with override)

    we tried it from another machine witht eh same error.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    May 2002
    Posts
    47
    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

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    May 2002
    Posts
    47
    that's why i said it was a bogus error.

    ie. someone tried to change 1 to 1.

    any other ideas?

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Is this behaviour is same when you tried from other machine?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  9. #9
    Join Date
    May 2002
    Posts
    47

    yes

    yes.

    -k

  10. #10
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Then its better to reinstall SQL server, first uninstall and remove referenced registry keys for SQL server - reboot the box and reinstall freshly.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  11. #11
    Join Date
    May 2002
    Posts
    47
    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.

  12. #12
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Its better to remove registry keys, to have clean install.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •