If you do this in isqlw you see this message on the output screen. All rights reserved. Privacy statement © 2016 Microsoft. Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New?
Frank http://www.insidesql.de http://www.familienzirkus.de FrankKalis, Dec 10, 2003 #2 satya Moderator It's an informational messages, not really an error message. When you change server settings, you run reconfigure. Just type RECONFIGURE and fire But what is the complete error message? Join Now For immediate help use Live now! https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d05a9f68-7f1c-41a1-a697-4fb361d779d3/error-15457-severity-0-state-1?forum=sqlsecurity
Join our community for more solutions or to ask questions. Data:0000: 61 3c 00 00 00 00 00 00 a<......0008: 0b 00 00 00 41 00 5a 00 ....A.Z.0010: 44 00 4f 00 52 00 43 00 D.O.R.C.0018: 43 00 4d Get 1:1 Help Now Advertise Here Enjoyed your answer? I would appreciate any assistance on this.
I did go into the Server Properties a couple of time through EM and then X'd out. If no, please run "netstat -nab >d:\portlist.txt" from command line to check which process is using the tcp port and kill the process. You cannot edit your own topics. Note the severity: 0.
I thought the errors might be related.. Posted by Sakthi at 10:40 PM No comments: Post a Comment Please do not spam! Run the RECONFIGURE statement to install." Does anyone know if I can turn OFF the event logging of this message. http://www.sql-server-performance.com/forum/threads/error-15457-severity-0-state-1.4030/ Report Abuse.
I think I'll be getting a lot of support calls about this if I can't figure out a way to make it stop writting this to the event log Any insight any other ideas? ------------ Ray Miao at 5/3/2002 2:16:45 PM Use manage message in sql em to see if you enable 'always write to event log'. ------------ Patricia Rotman at 5/3/2002 Tony Tbunosso, Dec 10, 2003 #2 FrankKalis Moderator Well, running the RECONFIGURE command from QA is simple. MS SQL Server Query Current Session Information via SQL Video by: Steve This videos aims to give the viewer a basic demonstration of how a user can query current session information
Run the RECONFIGURE statement to install.. 2003-09-27 00:03:34.70 backup Database backed up: Database: SMS_FAM, creation date(time): 2003/09/20(10:08:01), pages dumped: 1971, first LSN: 17:9671:1, last LSN: 17:9673:1, number of dump devices: 1, Run the RECONFIGURE statement to install..I'm not sure what to make of these errors or how to begin researching.. Come on over! Now again run sp_readerrorlog and you can notice this error message recorded.
You may have to register before you can post: click the register link above to proceed. It is confusing to the end users of our product that uses SQL 2000 as a back-end. Error: 15457, Severity: 0, State: 1 All refer to SPID 51 SPID51 is me, logged in via Windows Authentication. Run the RECONFIGURE statement to install..2009-10-14 16:25:24.64 spid51 Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.I have checked every configuration setting that I can think of and even had
You cannot post or upload images. Join the community of 500,000 technology professionals and ask your questions. Also, I don't remember reconfiguring or changing the properties of my server in EM or otherwise.
SQL Error 15457 Unanswered Question VON CLAWSON Oct 25th, 2005 I'm getting the following in the event viewer on the publisher. You cannot delete other events. Home Articles Tips FAQ Books Software SQL Server Scripts Forum   Log in or Sign up SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Posts > SQL Server 7.0 I know its just an informational message but it is filling the event log.
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 Do you know how not to get it anylonger? You cannot post HTML code. Check your sql server error log again to see if there is information regarding listening on the tcp port 1433.
Please enable it first via running server network utility C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe, enable TCP/IP protocol and check if the TCP port is 1433. Some of our product's code issues the sp_configure command that causes this message.