Page History

...

1. 1. Go back to Integrations and click the Add Connector button. 
      
      

      Info
      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.

      
      
   2. Fill in all of the following required fields. 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 have to select the device name where you manually installed the MSPbots Agent. You can find the device name in the Agent selection box. Select the one under the corresponding gateway of the database.

      • Click Save And Sync. 

Create a dataset and validate the data.

...

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

...

Common Issue

Issue Description:

...

       The The SQL Server encountered an issue of being is unable to connect to the database.

     Image Removed

Solution steps:

Image Added

Do the following steps to resolve the issue: 

1. Download DBeaver.
2. Install To download DBeaver, simply follow this link: https://dbeaver.io/download/and install it on the computer where you have installed the SQL Agent Client is installed. 
3. Launch DBeaver and connect to the SQL Server.Image Removed
   
   Image Added
4. Please input Enter your account, password, host, and port number. Click Test Connection and check for any errors.Image Removed
   Image Added
5. If an error occurs as shown in the following figure, please perform the following steps. Image Removed
   Image Added 
6. Retrieve Please retrieve the port number of your SQL Server through querying.Image RemovedImage Removed
   Image Added
   Image Added
7. Follow these steps to To modify the port number of your SQL Server, please follow these steps:.
   1. Click MSPbots > Integrations.
   2. Type 'SQL Agent' in the search box.
   3. Please modify Modify the port number of the SQL Server where the error occurred to match the port number of your SQL Agent. Image Removed
      
      Image Added
      PS:
      

      Info

      The

      The Database IP information configuration rules: For SQL

      Server

      Server  Default instance + Default port (1433): IP Default instance + Custom port: IP, XXXX Named instance + Default port: IP\ Instance Name Named instance + Custom port: IP\ Instance Name,

      XXXX

      XXXX  For My

      SQL

      SQL  The Database uses the default port (3306):

      IP  

      IP  The Database uses a custom port number: IP;port=XXXX

      
      
8. Restart SQL Server to ensure the changes made take effect.

          Image RemovedImage Added