Difference between revisions of "How To: Install and configure the Remote Log Data Loader component for ISA/TMG when logging to MSDE"

From burstekwiki
Jump to: navigation, search
 
Line 57: Line 57:
 
[[File:LASE_Port_Flow.png|thumb|none|alt=LASE Port Flow|LASE Port Flow]]
 
[[File:LASE_Port_Flow.png|thumb|none|alt=LASE Port Flow|LASE Port Flow]]
 
</cl>
 
</cl>
 +
 +
 +
 +
[[Category:LogAnalyzer_SE]]
 +
[[Category:LASE: How To]]

Latest revision as of 18:42, 3 March 2014

[edit] LASE: Installation and configuration of the Remote Log Data Loader component

  1. Determine the Dynamic port being used for SQL Server on your LASE SQL Server:

    1. Open the SQL Server Configuration Manager for the SQL Server that the LASE databases are installed on

    2. Locate the 'TCP/IP' protocol for the instance that is used for the LASE databases and navigate to the properties by right-clicking and selecting 'Properties'

    3. In the 'TCP/IP Properties' windows, select the 'IP Addresses' tab

    4. Record the 'TCP Dynamic Ports' value for the 'IPALL' section. (You can force SQL to use a different port by typing in the desired port number in the TCP Port field.)

    TCPIP Properties Window
    TCP/IP Properties Window

    Note Note: For more information on the SQL Server Instance dynamic ports, see:

  2. Create the necessary rules in ISA/TMG to allow communication between the related servers. The rules are listed in the table below:


    IP Port Protocol Direction Client Host Destination Host Users
    1433 Microsoft SQL (TCP) TCP/Outbound ISA/TMG Server SQL Server All Users
    1434 Microsoft SQL (UDP) UDP/Send Receive ISA/TMG Server SQL Server All Users
    (SQL Instance Dynamic Port) Custom/User Defined TCP/Outbound ISA/TMG Server SQL Server All Users
    8082 Custom/User Defined TCP/Outbound ISA/TMG Server LASE Main Server All Users
    8083 Custom/User Defined TCP/Outbound ISA/TMG Server LASE Main Server All Users
    8083 Custom/User Defined TCP/Outbound LASE Main Server ISA/TMG Server All Users
    8086 Custom/User Defined TCP/Outbound LASE Main Server ISA/TMG Server All Users
  3. Make sure the LogAnalyzer SETM server's local firewall does not block any communication on the previously-mentioned ports

  4. Install the Remote Data Loader on the ISA or TMG server with the MSDE or SQL Express proxy logs:

    1. Run the bt-LogAnalyzer SE ‘Setup.exe’ file

    2. Click ‘Next’ to continue the installer

    3. Read and accept EULA, then click ‘Next’

    4. Read and accept third-party Components license agreement, then click ‘Next’

    5. Accept and/or change the installation destination, then click ‘Next’

    6. Select the ‘Remote Log Data Loader’ option and click ‘Next’

    7. Type in the IP address or hostname of the server where the main installation of LogAnalyzer SE is located, then click ‘Next’

    8. Enter the Service account ( Note Note: Input the service account in the ‘DOMAIN\username’ format) that is used for the LA7* services on the LogAnalyzer SE server. Make sure this service account is a local administrator on the ISA/TMG server. Click ‘Next’.

    9. Click ‘Next’ to proceed with the installation

    10. If the installation has succeeded successfully, click ‘Finish’

  5. Create and configure the Log Source for the remote MSDE/SQL Express log data:

    1. On the Main LogAnalyzer SE server, create a new log source

    2. Select the ‘MSDE Database’ option for the ‘Log Source Type’

    3. Navigate to the ‘Advanced’ tab of the new log source properties window

    4. Mark the check box labeled ‘Use remote server for this Log Source’

    5. Type in the IP address or hostname of the remote ISA/TMG server where the proxy logs reside, then click ‘Apply’

    6. Navigate back to the ‘Common Options’ tab in the new log source properties window, then click the ‘Test’ button located in the lower portion of the page

    7. You should receive a ‘Test succeeded. Log source is not empty.’ Message. If the test fails, make sure the LogAnalyzer SE Main server’s local firewall is not blocking communication. If you have confirmed that this is not the cause of the test failure, configure the ISA/TMG server to monitor all traffic between all 3 servers (LogAnalyzer SE Main, ISA/TMG Server, SQL Server)

    8. Once the test has succeeded, click ‘Ok’

  6. Load and categorize your new log source

    LASE Port Flow
    LASE Port Flow
Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox