SQL Server Performance Forum – Threads Archive

error: 15457, severity:0, state:1

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

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

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

quote:Originally posted by satya And its an information message, no need to worry. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

One day I’ll learn to look first at Severity: 0 [:I] Frank
http://www.insidesql.de
http://www.familienzirkus.de

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)

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

Like satya mentioned, no need to worry Frank
http://www.insidesql.de
http://www.familienzirkus.de

What is the level of service pack on SQL?
And as referred its an informational message. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

It is version 8.00.760 SP3

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

You must be a SYSADMIN to perform the action of such configuration statements, on further note with error log see http://sqlserver-qa.net/blogs/tools…ed-sql-server-not-found-or-access-denied.aspx that explains a real problem in your SQL enviornment

]]>