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!
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 need to give MSPbots read-only access to your company's SQL server so that we can pull data from your server without modifying or deleting entries. Read-only access to your database also helps us create datasets for your use.
This guide has the steps for granting read-only access to your SQL server.
To create a read-only account for MSPbots:
- Log in to SQL Server Management Studio and right-click on New Logins.
- On the Login Properties - mspbots window, type mspsqlagent on the field for Login name and select the SQL Server authentication radio button.
- Enter and confirm the Password, and tick the checkboxes for Enforce password policy and Enforce password expiration.
- Next, go to User Mapping. Select the database that you want to synchronize and put checkmarks on the checkboxes for db_datareader and public.
- Then, go to Status > Settings. Open the account by selecting the radio buttons for Grant under Permission to connect to database engine, and Enabled under Login.
- Click OK to save the settings.
Related Topic
Overview
Content Tools