SQL Server Performance

error: 15457, severity:0, state:1

Discussion in 'General DBA Questions' started by Tbunosso, Dec 10, 2003.

  1. Tbunosso New Member

    All,
    Am a very green SQL Server DBA.... Just created a new SQL Server instance & installed SP3. I'm seeing multiple occurances of the following error in the :

    Error: 15457, Severity: 0, State: 1

    Most suggestions I've seen have mentioned running the RECONFIGURE statement to fix. Just how does one do that?

    Thanks in advance for your time.

    Tony


  2. FrankKalis Moderator

    Well, running the RECONFIGURE command from QA is simple. Just type RECONFIGURE and fire

    But what is the complete error message?

    Note, that RECONFIGURE is only needed when some serverwide configuration options have changed and needs to be updated.

    Frank
    http://www.insidesql.de
    http://www.familienzirkus.de
  3. satya Moderator

    It's an informational messages, not really an error message. If you change your
    server properties or if you view them in Enterprise Manager, you will see this
    message. When you change server settings, you run reconfigure. You can find
    information reconfigure this in Books Online

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  4. FrankKalis Moderator

  5. Tbunosso New Member

    Frank,
    Thanks for your quick response

    here are the lines preceding the error in the Server Log

    • Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_msver'.
    • Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    • Error: 15457, Severity: 0, State: 1
    All refer to SPID 51

    SPID51 is me, logged in via Windows Authentication. Database: Master, status:runnabe, open transactions:2, command: SELECT INTO

    The last TSQL command batch, for SPID51, is:
    dbcc inputbuffer(51)
  6. Tbunosso New Member

    Frank, Satya,
    Thank you both for your timely responses.

    I was just concerned, as we do not have these errors occuring on either of our 2 other boxes
  7. FrankKalis Moderator

  8. satya Moderator

    What is the level of service pack on SQL?
    And as referred its an informational message.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  9. Tbunosso New Member

    It is version 8.00.760 SP3
  10. BOSOF Pete New Member

    I am also a very green SQL DBA and I am getting the same error mesage, when I try to run the RECONFIGURE statement to fix the issue It the sql analyzer tells me I do not have the permissions to run this command. Can you tell me how to update the permissisons to fix this issue? I have also added some of the error log file I get when trying to log into the remedy application:
    Thu Oct 15 14:09:50 2009 390600 : Cannot initialize contact with SQL database (ARERR 551)
    Thu Oct 15 14:09:50 2009 Stop server
    Thu Oct 15 14:09:50 2009 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21)
    Thu Oct 15 14:10:48 2009 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key.
    For unlimited capabilities, contact your sales representative. (ARNOTE 27)
    Thu Oct 15 14:11:05 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:11:05 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    Thu Oct 15 14:11:05 2009 390600 : SQL database is not available -- will retry connection (ARNOTE 590)
    Thu Oct 15 14:11:37 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:11:37 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    Thu Oct 15 14:12:15 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:12:15 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    Thu Oct 15 14:12:47 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:12:47 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    Thu Oct 15 14:13:18 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:13:18 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    BOSOF Pete
  11. satya Moderator

  12. BOSOF Pete New Member

    I am also a very green SQL DBA and I am getting the same error mesage, when I try to run the RECONFIGURE statement to fix the issue It the sql analyzer tells me I do not have the permissions to run this command. Can you tell me how to update the permissisons to fix this issue? I have also added some of the error log file I get when trying to log into the remedy application:
    Thu Oct 15 14:09:50 2009 390600 : Cannot initialize contact with SQL database (ARERR 551)
    Thu Oct 15 14:09:50 2009 Stop server
    Thu Oct 15 14:09:50 2009 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21)
    Thu Oct 15 14:10:48 2009 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key.
    For unlimited capabilities, contact your sales representative. (ARNOTE 27)
    Thu Oct 15 14:11:05 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:11:05 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    Thu Oct 15 14:11:05 2009 390600 : SQL database is not available -- will retry connection (ARNOTE 590)
    Thu Oct 15 14:11:37 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:11:37 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    Thu Oct 15 14:12:15 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:12:15 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    Thu Oct 15 14:12:47 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:12:47 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    Thu Oct 15 14:13:18 2009 390600 : Failure during SQL operation to the database (ARERR 552)
    Thu Oct 15 14:13:18 2009 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17)
    BOSOF Pete

Share This Page