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
What is the level of service pack on SQL? And as referred its an informational message. _________ Satya SKJ Moderator SQL-Server-Performance.Com
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
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
