Verify that Microsoft SQL server used for the vRealize Automation database is sending syslog data to the vRealize Log Insight cluster.

About this task

Validating that agent communication between the Microsoft SQL Server and the vRealize Log Insight cluster ensures that the agent is configured correctly and that there is network connectivity.

Expected Outcome

The Microsoft SQL Server is listed in the vRealize Log Insight agent list and has Active Status.

Procedure

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

      Setting

      Value

      User name

      admin

      Password

      vrli_admin_password

  2. Click the configuration drop-down menu icon and select Administration.
  3. Under Management, click Agents.
  4. From the All Agents drop-down menu, select vRA - SQL Agent Group.
  5. Verify that the Microsoft SQL Server is listed and has Active Status.

What to do next

If you encounter issues while performing this procedure, use the following troubleshooting tips:

Troubleshooting Tips

  • Ensure that the vRealize Log Insight agent service is running on the virtual machine.

  • Ensure that there is network connectivity between the systems.