Page History

...

1. Log in to MSPbots. Go to Integrations then search for SQL Agent.
   

2. Open SQL Agent and click on the Download link to download the MSPbots SQL Agent Client file to the SQL Server Management computer.
   

3. Execute MSPbots SQL Agent.exe as an administrator.  
   
   

4. Go back to the MSPbots app. Copy the Secret and Data Server strings from the SQL Agent page to the Setup window.
   

5. Complete the installation by clicking Next on the Setup window.
    

6. Next, run the MSPbots MS-SQL Server Agent as an administrator. 

7. Return to the MSPbots app and click the + Add Connector button. 
   
   

8. Expand the drop-down options for SQL Server // and enter the following:
   1. IP 
   2. Database Name
   3. User ID 
   4. Password
      
   5. Optional step:
      you can use Use the following SQL as an example to create a readonly read-only DB user and password. (please Please change the password to '123456'.)
      

      GRANT SELECT ON *.* TO 'mspbots_sql_agent'@'%' IDENTIFIED BY '123456';
      
      

9. Click Save And Sync.

   Note
   title Important
   The following operations will be completed with assistance from MSPbots support.

   
   

10. On the MSPbots app, go to Datasets. Choose a dataset and click the ellipsis ... > Edit. 
    

11. When the Edit window appears, find the Data Cleaning tab, click it, and select SQL as Refresh Type. 
    

12. Click the add icon and set the configurations for the SQL agent. 
    
13. Click Save to start data sync with MSPbots. 

...