Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

    1. Open the Agent client by double-clicking on the shortcut you created in Step 2e above. 
    2. Go back to Integrations and click the Add Connector button.
      add connector
    3. Scroll down to the SQL Server section and select a Database type.
      sql server database config 
    4. Log in using your MSPbots account. You can Minimize or Close the window after login but do not log out. 
      login agent client
    5. Once logged in, navigate back to the Integrations section of the MSPbots app. Find the SQL Agent connection and provide all of the following required info: 
      SQL agent infoImage Added
      A. Database Type - Select either SQL Server or MySQL.
      B. Agent - The agent will auto-populate with the machine name you installed.
      C. IP - Provide the internal IP address or FQDN of the SQL or MySQL server.
      D. Database Name

       


      E. Time Zone - Select your time zone.

       


      F. User ID - This is the username of the user with read-only access to the database.
      G. Password - This is the password of the user with read-only access to the database.


      SQL agent infoImage Removed



      Note

      Please note it may take a few moments for the agent to check in after installation.

    6. Click Save And Sync
    7. Refresh your browser. 

...