none
Service Broker External Activator Issue RRS feed

  • Question

  • Hi All,

    I am trying to configure service broker external activator service on SERVER2 ,in my database server (SERVER1) i have two installations of sql server one is 2012 and another one is 2017, i have enabled and created all the objects related to service broker in 2012 instance (SERVER1\SQL2012). But after starting the service broker external activator  service i am getting the below error in the EATrace.log file. 

    1/16/2019 3:42:44 PM ====== ================================================================================
    1/16/2019 3:42:44 PM ====== ================================================================================
    1/16/2019 3:42:44 PM INFO The External Activator service is starting.
    1/16/2019 3:42:44 PM INFO Initializing configuration manager ...
    1/16/2019 3:42:44 PM INFO Reloading configuration file C:\Program Files\Service Broker\External Activator\config\EAService.config ...
    1/16/2019 3:42:44 PM INFO Reloading configuration file completed.
    1/16/2019 3:42:44 PM VERBOSE Running recovery using recovery log file C:\Program Files\Service Broker\External Activator\log\EARecovery.rlog ...
    1/16/2019 3:42:44 PM VERBOSE Checkpointing recovery log C:\Program Files\Service Broker\External Activator\log\EARecovery.rlog ...
    1/16/2019 3:42:44 PM VERBOSE Checkpointing recovery log completed.
    1/16/2019 3:42:44 PM VERBOSE Running recovery completed.
    1/16/2019 3:42:44 PM INFO Initializing configuration manager completed.
    1/16/2019 3:42:44 PM VERBOSE Starting worker threads...
    1/16/2019 3:42:44 PM VERBOSE Worker threads are successfully started.
    1/16/2019 3:42:44 PM INFO The External Activator service is running.
    1/16/2019 3:42:44 PM VERBOSE Heartbeat-Thread is starting...
    1/16/2019 3:42:44 PM VERBOSE CM-NS-Thread is starting...
    1/16/2019 3:42:58 PM EXCEPTION ERROR = 30, The connection to the notification server failed.
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS Inner Exception:
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean withFailover)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at System.Data.SqlClient.SqlConnection.Open()
    1/16/2019 3:42:58 PM EXCEPTIONDETAILS    at ExternalActivator.NotificationService.get_Connection()

    my EAService.config looks like below

    <?xml version="1.0" encoding="utf-8"?>
    <Activator xmlns="http://schemas.microsoft.com/sqlserver/2008/10/servicebroker/externalactivator"
               xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
               xsi:schemaLocation="http://schemas.microsoft.com/sqlserver/2008/10/servicebroker/externalactivator EAServiceConfig.xsd"
               >
      <NotificationServiceList>
        <NotificationService name="AUDIT_NOTIFICATION_SERVICE" id="100" enabled="true">
          <Description>Tracking Notification Service</Description>
          <ConnectionString>
            <!-- All connection string parameters except User Id and Password should be specificed here -->
            <Unencrypted>server=SERVER1\SQL2012;database=SBEA_DB;Application Name=AuditTrailMessageReceiver;Integrated Security=true;</Unencrypted>
          </ConnectionString>
        </NotificationService>
      </NotificationServiceList>
      <ApplicationServiceList>
        <ApplicationService name="AuditTrailMessageReceiver" enabled="true">
          <OnNotification>
            <ServerName>SERVER1\SQL2012</ServerName>
            <DatabaseName>SBEA_DB</DatabaseName>
            <SchemaName>dbo</SchemaName>
            <QueueName>AUDIT_REQUEST_QUEUE</QueueName>
          </OnNotification>
          <LaunchInfo>
            <ImagePath>C:\HostedApplications\AuditTrailMessageReceiver\AuditTrailMessageReceiver.exe</ImagePath>
            <CmdLineArgs></CmdLineArgs>
            <WorkDir>C:\HostedApplications\AuditTrailMessageReceiver</WorkDir>
          </LaunchInfo>
          <Concurrency min="1" max="1" />
        </ApplicationService>
      </ApplicationServiceList>
      <LogSettings>
        <LogFilter>
    	<TraceFlag>All Levels</TraceFlag>
          	<TraceFlag>All Modules</TraceFlag>
          	<TraceFlag>All Entities</TraceFlag>
          	<TraceFlag>Verbose</TraceFlag>
        </LogFilter>
      </LogSettings>
    </Activator>

    To check the database connectivity from SERVER2 i have created a small console application and it was able to connect to database server without any issues. The following is my app.config file connection string settings

    <connectionStrings>
        <add name="SBEACS"
        connectionString="Data Source=SERVER1\SQL2012;Initial Catalog=SBEA_DB;Integrated Security=True"/>
      </connectionStrings>

    Please any one help me to correct this issue.

    Thanks in advance 

    Arun

    Wednesday, January 16, 2019 5:44 PM

All replies

  • The server was not found or was not accessible.

    Hello Arun,

    SSSB runs as a Service with a Service account; do this account have access permissions to logon SQL Server and the database? Review SQL Server ErrorLog if there are logon Errors.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, January 17, 2019 7:26 AM
  • Hi Olaf Helper,

    Thank you so much for your response.

    I confirm the service account has access permission for SQL server and the database. 

    I have tested same on our development server it was working, when I tried to move it to QA server the problem started. The QA server has two sql server installation 2012 & 2017 and the dev server has only ms sql server 2012, that is the only difference.

    Arun 



    • Edited by aruntb Friday, January 18, 2019 5:34 PM
    Friday, January 18, 2019 5:24 PM
  • Hi Arun,

    since you are running 2017 & 2012 on the same machine and you are mixing the SQL versions, I think you need to install the newest one i.e. SQL 2017 Feature Pack and use it as a Service (https://www.microsoft.com/en-us/download/details.aspx?id=55992 ). SQL 2017 - Implementation is aware of SQL 2012 but SQL 2012-Implemenation is not aware of SQL 2017 

    BR

    Bobi

    Tuesday, January 22, 2019 7:26 PM
  • Hi Arun, have you found a fix for this issue? thanks. Goran
    Thursday, December 12, 2019 5:50 PM