Page History

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

Verify if you are using a previous version of SQL Agent.

If you have SQL Agent 3.0 installed, proceed to Step 2. If an older version is installed, uninstall it first with the following steps:  

1. 1. Go to the Agent installation directory. 
   2. Find the unins000.exe file and run it. 
      Image Removed 

...

...

Complete the prerequisites. 

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 Added
      
   2. On the Network and Sharing Center, click your Connection. 
      Image Added
      
   3. When the Wi-Fi Status window appears, click the Properties button. 
      Image Added
   4. Take note of your IPv4 Address. 
      Image Added
      

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 Added
   2. Click OK.

Connect the MSPbots agent. 

1. 1. Go to Integrations on the MSPbots app menu. 
   2. Find the SQL Agent and click the Config icon.
      
   3. Next, click the download icon for the MSPbots SQL Agent Client to start downloading the installer file.
      
   4. Locate and double-click on the downloaded installer.
   5. During the setup, select Automatic start and Create a desktop shortcut, then click Next. 
      
   6. Follow the prompts. In the last step, tick the Launch MSPbotsAgentService checkbox and click Finish. The window will automatically close when the service starts.
      
       

...

1. 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.
      Image Added
   3. Scroll down to the SQL Server section and select a Database type.
      Image Added 
   4. Log in using your MSPbots account. You can Minimize or Close the window after login but do not log out. 
      
   5. Go

      Once logged in, navigate back to the Integrations

      and click the Add Connector button.
      Image Removed
   6. Scroll down to the SQL Server section and select a Database type.
      Image Removed 

   7. section of the MSPbots app. Find the SQL Agent connection and provide all of the following required info:

      • Database Type - Select either SQL Server or MySQL.
      • Agent - The agent will auto-populate with the machine name you installed.
      • IP - Provide the internal IP address or FQDN of the SQL or MySQL server.
      • Database Name 
      • Time Zone - Select your time zone. 
      • User ID - This is the username of the user with read-only access to the database.
      • Password - This is the password of the user with read-only access to the database.
        Image Added
   8. Click Configure the following database information:
      For SQL Server 
      The Database IP information configuration rules are:
      Default instance + Default port (1433): IP
      Default instance + Custom port: IP,XXXX
      Default instance + Custom port: IP\ Instance Name,XXXX 
      For My SQL
      The Database uses the default port (3306): IP 
      The Database uses a custom port number: IP;port=XXXX 
      Image RemovedAfter the configuration is complete, click Save And Sync. 
   9. Refresh your browser. 

...