Ms Sql Server Error 15457
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » Error: 15457, Severity: 0, State: 1 Error: 15457, Severity: 0, State: 1 Rate Topic Display Mode Topic Options Author Message JpotucekJpotucek Posted Wednesday, December 28, 2005 12:46 PM Right there with Babe Group: General Forum Members Last Login: Thursday, October 13, 2016 8:38 AM Points: 786, Visits: 1,647 I am getting these errors in my event log periodically:Error: 15457, Severity: 0, State: 1and thenConfiguration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..I'm not sure what to make of these errors or how to begin researching.. can anyone help?? Post #247019 noeldnoeld Posted Wednesday, December 28, 2005 12:52 PM SSCertifiable Group: General Forum Members Last Login: Yesterday @ 9:27 AM Points: 6,262, Visits: 2,048 I've seen this type of messages when monitoring tools change the 'show advanced options' and forget to execute RECONFIGURE after it.because this is a server wide setting all that is needed is for you to run RECONFIGURE maually. This is not a big problem but you will need to look for the offending party if you want to get rid of this message on the sql logsCheers, * Noel Post #247022 Joshua Jones-214598Joshua Jones-214598 Posted Wednesday, December 28, 2005 12:58 PM SSC Veteran Group: General Forum Members Last Login: Tuesday, December 5, 2006 7:27 AM Points: 235, Visits: 1 The other thing that causes this is simply opening up the server properties dialog in Enterprise Manager and clicking OK to exit instead of Cancel (i.e. a DBA goes to look at the Startup Parameters, then after verifying clicks the OK button to close the dialog box). Cheers,Joshua Jones Post #247023 JpotucekJpotucek Posted Wednesday, December 28, 2005 1:15 PM Right there with Babe Group: General Forum Members Last Login: Thursday, October 13, 2016 8:38 AM Points: 786, Visits: 1,647 Thank you. I did go into the Server Properties a couple of time through EM and then X'd out. maybe that
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums SQL Server Administration (2000) Error: 15457, Severity: 0, State: 1 Reply to Topic Printer Friendly Author http://www.sqlservercentral.com/Forums/Topic247019-5-1.aspx Topic asarak Starting Member Greece 36 Posts Posted-12/07/2005: 06:52:38 Hi Guys, i ve got a problem.Suddenly while i was trying to get into the Enterprise Manager -- In the Current Activity, to see the locks i receive the following message:Error 1222, Lock request time out period exceeded.I am looking also to the log and saw the error:Error: 15457, http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58726 Severity: 0, State: 1I am trying from the server console itself but there is the same effect... Some times work but others (mostly) failed...I also check the query timeout option in the server and i found that is about 600 ms (not 0 which is unlimited) but this was changed many months ago.Thanks a lotAny suggestions???RegardsAsarak SQLServerDBA_Dan Aged Yak Warrior USA 752 Posts Posted-12/07/2005: 08:39:15 quote:Originally posted by asarakI am looking also to the log and saw the error:Error: 15457, Severity: 0, State: 1This error appears when you open the server properties in Enterprise Manager. It's more informational than an actual error. I wouldn't worry too much about it.quote:Originally posted by asarakSuddenly while i was trying to get into the Enterprise Manager -- In the Current Activity, to see the locks i receive the following message:Error 1222, Lock request time out period exceeded.I also check the query timeout option in the server and i found that is about 600 ms (not 0 which is unlimited) but this was changed many months ago.Do you mean the "query timeout" option in Query Analyz
State: 1 un the RECONFIGURE statement to install Error Message:Error: 15457, Severity: 0, State: 1Configuration option show advanced options changed from 1 http://ms-sql-server-dba.blogspot.com/2009/02/error-15457-severity-0-state-1-un.html to 1. Run the RECONFIGURE statement to install..Root Cause:Not running RECONFIGURE Statment after changing server optionsThis normally happens when we open Server Properties in Enterprise Manager and Click "OK" button instead of "Cancel" button in SQL 2000.To prevent this error from being logged, always click Cancel button in the Properties windows incase you are not changing anything.To confirm ms sql above statement follow below steps:1. Open query analyser.2. Run sp_cycle_errorlog command to recycle error logs.3. Now run sp_readerrorlog and you will notice that error log has 10 lines.4. Now open EM and perform above root cause.5. Now again run sp_readerrorlog and you can notice this error message recorded. Posted by Sakthi at 10:40 PM No comments: Post ms sql server a Comment Please do not spam! Newer Post Older Post Home Save as PDF Categories 64-bit Administration Backup BCP Blocking Browser Service Certification Clustering Connectivity Corruption Database Mail DB Mirroring DBA Editorial Disk Driver DSN DTC FILEGROUP Full Text Hardware Info Job Kereberos Known Issues Linked Server Locks Log shipping Maintenance Plans Memory Migration Monitoring Named Pipes Network OLEDB Oracle Connectivity Out-of-Box Performance Profiler Programming Protocols Replication Security Server Options Setup SQL 2000 SQL 2005 SQL 2008 SQL Express SQL Server Agent SSAS SSIS SSRS Startup Errors T-SQL Tips Troubleshooting Upgradation About me Sakthi SQL Server DBA Bangalore India View Profile Resources Privacy Google, as a third party vendor, uses cookies to serve ads on this site. Google's use of the DART cookie enables it to serve ads to this site users based on their visit to this site and other sites on the Internet.*Users may opt out of the use of the DART cookie by visiting the Google ad and content network privacy policy at the following URL Thanks! Tha