Install the new content pack for Microsoft SQL Server to add the dashboards for viewing log information about the database platform hosting the Cloud Management Platform in vRealize Log Insight.

About this task

You install the following content packs:

  • Microsoft - SQL Server

Procedure

  1. Log in to the vRealize Log Insight user interface.
    1. Open a Web browser and go to https://vrli-cluster-01.sfo01.rainpole.local.
    2. Log in using the following credentials.

      Setting

      Value

      User name

      admin

      Password

      vrli_admin_password

  2. In the vRealize Log Insight user interface, click the configuration drop-down menu icon  and select Content Packs.
  3. Under Content Pack Marketplace, select Marketplace.
  4. In the list of content packs, locate the Microsoft - SQL Server content pack and click its icon.
  5. In the Install Content Pack dialog box, click Install.

    After the installation is complete, the Microsoft - SQL Server content pack appears in the Installed Content Packs list on the left

  6. Repeat the procedure to on vrli-cluster-51.lax01.rainpole.local
  7. In the vRealize Log Insight Web user interface, configure the Log Insight Windows Agent Group for the Microsoft SQL Server component that is used by vRealize Automation.
    1. Open a Web browser and go to https://vrli-cluster-01.sfo01.rainpole.local.
    2. Log in using the following credentials.

      Setting

      Value

      User name

      admin

      Password

      vrli_admin_password

    3. Click the configuration drop-down menu icon  and select Administration.
    4. Under Management, click Agents.
    5. From the drop down on the top, select Microsoft - SQL Server from the Available Templates section..
    6. Click Copy Template.
    7. In the Copy Agent Group dialog box, enter vRA7 - Microsoft SQL Server Agent Group in the name text box and click Copy.
    8. In the agent filter fields, use the following selections.

      Use ENTER to separate the host name values.

      Filter

      Operator

      Values

      Hostname

      matches

      vra01mssql01.rainpole.local

    9. Under Agent Configuration, click Edit
    10. Locate directory=C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log and change it to directory=C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log
      Note:

      In this VMware Validated Design, Microsoft SQL Server 2012 R2 has been installed in the default location on the Windows Server virtual machine.

    11. Click Refresh and verify that all the agents listed in the filter appear in the Agents list.
    12. Click Save New Group at the bottom of the page.

Results