none
SSBS External Activation Event Notification Server Alias

    Question

  • Hi There,

    I am using External Activation on SQL Server 2008 R2.

    In the ExternalActivatorQueue we have the following message,

    <EVENT_INSTANCE>

      <EventType>QUEUE_ACTIVATION</EventType>

      <PostTime></PostTime>

      <SPID>777</SPID>

      <ServerName>TestServer</ServerName>

      <LoginName>MyLogin</LoginName>

      <UserName>dbo</UserName>

      <DatabaseName>MyBroker</DatabaseName>

      <SchemaName>dbo</SchemaName>

      <ObjectName>MyQueue</ObjectName>

      <ObjectType>QUEUE</ObjectType>

    </EVENT_INSTANCE>

    The ServerName is the SQL Server Name and in the EAService.config file,

    the ServerName has to match.

    <ApplicationServiceList>
        <ApplicationService name="MyService" enabled="true">
          <OnNotification>
            <ServerName>TestServer</ServerName>
            <DatabaseName>MyBroker</DatabaseName>
            <SchemaName>dbo</SchemaName>
            <QueueName>MyQueue</QueueName>
          </OnNotification>

    The question we have is, is it possible to set the ServerName in the OnNotification tag within the EAService.config to an alias?

    This can already be done in the SQL connection within the EAService.config

     <NotificationService name="MyService" id="999" enabled="true">
          <Description>My Test</Description>
          <ConnectionString>

           <Unencrypted>server=NetworkServerAlias;database=MyBroker;Application Name=My External Activator Service DB;Integrated Security=true;</Unencrypted>
          </ConnectionString>
        </NotificationService>
     

    Which I guess would mean the ServerName in the Event Instance would need to change to.


    Cheers

    Friday, July 12, 2013 2:29 PM

Answers