none
Error: 15457, Severity: 0, State: 1

    Question

  • I am getting the following error message when trying to access the instance of the Action request system on my SQL Server :
    ARERR [90] Cannot establish a network connection to the AR System server : pete-qxm9ydauvr. (0) : RPC: Program not registered

     user: Demo,  server: pete-qxm9ydauvr.

    Unable to successfully log in to any server.


    In my error log I have the following:
    2009-10-14 14:46:51.35 server    Copyright (C) 1988-2000 Microsoft Corporation.
    2009-10-14 14:46:51.35 server    All rights reserved.
    2009-10-14 14:46:51.35 server    Server Process ID is 504.
    2009-10-14 14:46:51.35 server    Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
    2009-10-14 14:46:51.37 server    SQL Server is starting at priority class 'normal'(2 CPUs detected).
    2009-10-14 14:46:51.40 server    SQL Server configured for thread mode processing.
    2009-10-14 14:46:51.40 server    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
    2009-10-14 14:46:51.43 server    Attempting to initialize Distributed Transaction Coordinator.
    2009-10-14 14:46:53.45 spid3     Starting up database 'master'.
    2009-10-14 14:46:53.60 server    Using 'SSNETLIB.DLL' version '8.0.194'.
    2009-10-14 14:46:53.60 spid5     Starting up database 'model'.
    2009-10-14 14:46:53.62 server    SQL server listening on Shared Memory, Named Pipes.
    2009-10-14 14:46:53.62 server    SQL Server is ready for client connections
    2009-10-14 14:46:53.64 spid3     Server name is 'PETE-QXM9YDAUVR'.
    2009-10-14 14:46:53.64 spid8     Starting up database 'msdb'.
    2009-10-14 14:46:53.64 spid9     Starting up database 'pubs'.
    2009-10-14 14:46:53.64 spid10    Starting up database 'Northwind'.
    2009-10-14 14:46:53.64 spid11    Starting up database 'ARSystem'.
    2009-10-14 14:46:54.17 spid5     Clearing tempdb database.
    2009-10-14 14:46:54.92 spid5     Starting up database 'tempdb'.
    2009-10-14 14:46:54.98 spid3     Recovery complete.
    2009-10-14 15:00:44.70 spid51    Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'sp_MSgetversion'.
    2009-10-14 16:25:24.56 spid51    Error: 15457, Severity: 0, State: 1
    2009-10-14 16:25:24.56 spid51    Configuration option 'show advanced options' changed from 0 to 1. 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 some assistance and we still cannot find anything that would get rid of this error and allow me to access my remedy application.  I would appreciate any assistance on this.

    Wednesday, October 14, 2009 9:08 PM

Answers

  • Did you remotely connect to your SQL Server? It looks that the TCP/IP protocol was not enabled on your SQL Server. 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. Then restart your sql server service. Check your sql server error log again to see if there is information regarding listening on the tcp port 1433. 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. Also please make sure that your windows firewall has allowed the connection on the TCP port 1433.

    At the client, run "telnet servername 1433" from command line to make sure that you can connect to the sql server listening tcp port. If OK, try connection again.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Friday, October 16, 2009 11:39 AM
    Moderator

All replies

  • This is an informational message and not an error.When the sp_configure system stored procedure is run on a sql server following that you either need to run RECONFIGURE or RECONFIGURE WITH OVERRIDE. 
    Try to run RECONFIGURE WITH OVERRIDE and see the error log next time when you restart sql server.
    Thanks, Leks
    Wednesday, October 14, 2009 10:47 PM
  • I ran the sp_Configure system stored procedure and it did not fix the problem. I still have the same issue access the sql database. What else could I be missing Please advise, I have attached part of an error log from today


    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)

    Thursday, October 15, 2009 6:26 PM
  • Are you still facing the same error

     Error: 15457, Severity: 0, State: 1
    2009-10-14 16:25:24.56 spid51    Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install..


    Did u run reconfigure after setting any sp_copnfigure option ?
    But this it looks like something else ?


    Thanks, Leks
    Thursday, October 15, 2009 11:05 PM
  • Did you remotely connect to your SQL Server? It looks that the TCP/IP protocol was not enabled on your SQL Server. 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. Then restart your sql server service. Check your sql server error log again to see if there is information regarding listening on the tcp port 1433. 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. Also please make sure that your windows firewall has allowed the connection on the TCP port 1433.

    At the client, run "telnet servername 1433" from command line to make sure that you can connect to the sql server listening tcp port. If OK, try connection again.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Friday, October 16, 2009 11:39 AM
    Moderator