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!
Page History
This guide will help you perform the following tasks:
| Table of Contents |
|---|
...
How to
...
deploy the SQL Agent
...
on your SQL Server
- Log in to MSPbots. Go to Integrationsthen on the MSPbots app and search for SQL Agent.
- Open On the SQL Agent and , click on the Download link to download the MSPbots SQL Agent Client file to the . You will need to install this on your SQL Server Management computer.
- Execute the MSPbots SQL Agent .exe as an administrator.
- The installer will require you to enter the Go back to the MSPbots app. Copy the Secret and Data Server strings from the SQL Agent page to the Setup window.
values from Step 2. 
- Complete the installation by clicking Next on the Setup window.
- At the end of the Setup Wizard, you will be asked to launch Next, run the MSPbots MS-SQL Server Agent. Do not launch it because you need to run it as an administrator.
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
- Go to Integrations on Return to the MSPbots app and click search for SQL Agent.
- Click the + Add Connector button to add a data source then the SQL Server // button to expand the configuration space.
- You should have the same view as below once you have expanded the Expand the drop-down options for SQL Server //and . Next, enter the following:
- Database Type - Select the SQL server that you have.
- IP
- Database
- Name
- User ID
- Password
Optional: Use
| Note | ||
|---|---|---|
| ||
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'; |
Click Save And Sync.
| Note | ||
|---|---|---|
| ||
The following operations will be completed with assistance from MSPbots support. |
...
On the MSPbots app, go to Datasets. Choose a dataset and click the ellipsis ... > Edit. 
...
When the Edit window appears, find the Data Cleaning tab, click it, and select SQL as Refresh Type. 
...
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. |
Content by Label
Overview
Content Tools