N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
Page History
...
- Go to Integrations on the MSPbots app menu.
- Find the SQL Agent and click the Config icon.
- Next, click the download icon for the MSPbots SQL Agent Client to start downloading the installer file.
- Locate and double-click on the downloaded installer.
- During the setup, select Automatic start and Create a desktop shortcut, then click Next.
- Follow the prompts. In the last step, tick the Launch MSPbotsAgentService checkbox and click Finish. The window will automatically close when the service starts.
Set up the MSPbots Agent Client.
- Open the Agent client by double-clicking on the shortcut you created in Step 2e above.
- Go back to Integrations and click the Add Connector button.
- Scroll down to the SQL Server section and select a Database type.
- Log Launch the MSPbots agent and log in using your MSPbots account. You can Minimize or Close the window after login but do not log out.
Set up the MSPbots Agent Connector.
- Go back to Integrations and click the Add Connector button.
- Fill in Once this is complete, navigate back to the Integrations section of the MSPbots app. Find the SQL Agent connection and provide all of the following required info:fields.
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.Note Please note it may take a few moments for the agent to check in after installation.
- Go back to Integrations and click the Add Connector button.
...
Overview
Content Tools