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!

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

This guide will help you perform the following tasks: 

How to deploy the SQL Agent on your SQL Server

  1. Go to Integrations on the MSPbots app and search for SQL Agent.
    Integations
  2. On the SQL Agent, click the Download link to download the MSPbots SQL Agent Client file. You will need to install this on your SQL Server Management computer. 
    SQL agent
  3. Execute the MSPbots SQL Agent as an administrator.
    MSPbots SQL Agent.exe
  4. The installer will require you to enter the Secret and Data Server values from Step 2.
    secret_dataserver 
  5. Complete the installation on the Setup window.
    installation setup
  6. At the end of the Setup Wizard, you will be asked to launch the MSPbots MS-SQL Server Agent. Do not launch it because you need to run it as an administrator. 
    MSPbots MS-SQL Server Agent
    Now that we have installed the SQL Agent on your SQL Server, the next step that you need to do is to set up the configurations in MSPBots.

How to set up the MSPbots configuration 

  1. Go to Integrations on the MSPbots app and search for SQL Agent.
  2. Click the + Add Connector button to add a data source then the SQL Server // button to expand the configuration space. 
    SQL Agent
  3. You should have the same view as below once you have expanded the SQL Server //. Next, enter the following:
    • Database Type - Select the SQL server that you have. 
    • IP 
    • Database Name 
    • User ID 
    • Password


Important


SQL User

The SQL user needs read permission only. Use the following SQL script as an example to create a read-only DB user and password. 

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

Don't forget to change 123456 to your preferred password.


ConnectWise Automate (2021.1+)

After creating the SQL user, add the user to the labtech.users table with a negative user ID to prevent the account from getting modified by ConnectWise Automate. Users that are not in the labtech.users table automatically get their passwords updated and ConnectWise Automate users are modified to not allow access to the SQL database. 


 




  • No labels

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!