Page History

This guide will help you do the following steps for connecting the MSPbots SQL agent:  .

What's in this article:

Complete the prerequisites

...

...

Please create a new read-only account in your SQL Server or MySQL as follows: How to Create a Read-only Account for Your SQL Server or MySQL. If you already have a read-only account specifically for communicating with MSPbots, please skip this prerequisite.

Connect the MSPbots agent

The following is required to connect the agent: 

Internal IP of the SQL Server 

To get the internal IP: 

1. 1. Launch the Control Panel and open Network and Sharing Center. 
      Image RemovedGo back to Integrations and click the Add Connector 
      
   2. On the Network and Sharing Center, click your Connection. 
      Image Removed
      
   3. When the Wi-Fi Status window appears, click the Properties button. 
      Image Removed
   4. Take note of your IPv4 Address. 
      Image Removed
      

db_datareader permissions

1. 1. Open your SQL server and select db_datareader permissions for MSPbots.
      

      Warning
      Giving any account full DB access is not recommended.

       
      Image Removed
   2. Click OK.

...

...

1. 1. Go to Integrations on the MSPbots app menu. 
   2. Find the SQL Agent and click the Config icon.
      Image Modified
   3. Next, click the download icon for the MSPbots SQL Agent Client to start downloading the installer file.
      
Image RemovedLocate and double-click on the downloaded installer
2. 1. Image Added
   2. After the download is complete, follow the prompts to install the MSPbots SQL Agent client.
   3. During the setup, select Automatic
start
3. 1. Start and Create a desktop shortcut, then click Next. 
      Image Modified
Follow the prompts.
4. 1. In the last step, tick the Launch MSPbotsAgentService checkbox and click Finish. The window will automatically close when the service starts.
      Image Modified
   2. 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. 
      Image Modified

Set up the MSPbots Agent Connector

...

...

1. Go
back to 
2. to Integrations on the MSPbots app menu.
   Image Added
   
3. Search for SQL Agent and click it to open the connection settings. 
   Image Added
   
4. Click the +Add Connector button
Integrations and click the Add Connector button
5. . 
   Image Modified
   

   Info

Last

6. The last success auth shows the last time when the MSPbots Agent successfully pulled the database configuration information. By default, this process is set to occur every 5 minutes.

   
   
7. Fill in all of the following required fields.
It
8. It may take a few moments for the agent to check in after installation.
   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 the time zone used by the connected database.
   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. 

       Image Modified

       Note
       If you have installed multiple MSPbots agents with different databases in different network segments, you

   need

   • • have to select the device name where you manually installed the MSPbots Agent

   is installed. The agent is found

   • • . You can find the device name in the Agent selection box. Select the one under the corresponding gateway of the database

   in the Agent selection box

   • • .

   • Click Save And Sync. 

Create a dataset and validate the data

...

...

1. Go to Datasets on the MSPbots app menu and click the New Agent Dataset button. 
   
Image Removed
2. Image Added

3. When the New window appears,

click

4. click Integration and select SQL Agent. Don't forget to fill in the dataset Name and Description fields.

   Image Modified
5. Next, go to the Data Cleaning tab to show the Validate SQL section below.
   1. Select a database from
the
6. 1. the DB dropdown list. 
   2. Scroll down to the Validate SQL section, fill in the SQL field. The most common SQL statement to use here is
“select Image Removed
Scroll down to the Validate SQL section, fill in the SQL field, and input your desired
7. 1. “select * from TABLENAME”.
8. 1.  
   2. Input your desired 
9. 1. Sync Frequency in minutes.
      

      Tip
      Sync Frequency is currently limited to 30 minutes and can only be decreased for smaller datasets. For larger datasets, the frequency may be limited due to a large amount of data ingestion and the constraint it would place on both your server and ours.

Click
10. 1. 
       Image Added
11. Click Confirm when done. This will show a preview of the data for your validation. You can customize or use the default character length for string-type fields, and the time field can be set with a timezone.
    
Image Removed
12. Image Added
13. Once you confirm the data is correct, click OK to create and save the dataset. The data will be synchronized in 10 minutes.

Save the logs and send the file to MSPbots Support Team

...

...

1. Open the MSPbots Agent client and click the Save Log button on the upper right corner of the window. 
   Image Modified
2. Click Confirm on the Tips popup that appears. 
   
Image Removed 
3. Image Added
4. Next, select the location to save the logs, provide a filename, and click Save.
5. Send the file to support@mspbots.ai. 

Related Topics

...