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
...
- Log in to Micrisoft SQL Server Management Studio.
- Go to Logins under the Security section.
- Right-click Logins and select New Login to create a new account.
- At General tab, fill in the following fields.
- Login name - Set a unique Login name, for example, mspsqlagent.
- Check SQL Server authentication.
- Password - Set a password.
- Confirm Password - Confirm the password again.
- Uncheck Enforce password policy, Enforce password expiration and User must change password at next login.
---换图
- Click User Mapping.
In the User mapped to this login section, check the database name you want to synchronize with MSPbots, for example, autotest.
In the Database role membership for section, check db_datareader and public.
db_datareader - Permission to read data from your database.
- public - Permission to allow MSPbots access to your database.
Warning Giving any account full DB access is not recommended.
- Click Status.
- For the Permission to connect to the database engine option, check the Grant box.
- For the Login option, select Enabled.
- Click OK to save your settings.
...
Overview
Content Tools