• While I am executing below query on machine which is accessing from sql agent from out of LAN:

    SELECT

    CONNECTIONPROPERTY('net_transport') AS net_transport,

    CONNECTIONPROPERTY('protocol_type') AS protocol_type,

    CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,

    CONNECTIONPROPERTY('local_net_address') AS local_net_address,

    CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,

    CONNECTIONPROPERTY('client_net_address') AS client_net_address

    Mahesh D. Deore

    Nasik