Page History

...

1. Log in to Micrisoft SQL Server Management Studio. 
2. Go to Logins under the Security section.
3. Right-click Logins and select New Login to create a new account.
   
4. At General tab, fill in the following fields. 
   
   1. Login name - Set a unique Login name, for example, mspsqlagent.
   2. Check SQL Server authentication.
      
      1. Password - Set a password.
      2. Confirm Password - Confirm the password again.
      3. Check Enforce password policy.
      4. Check Enforce password expiration.
      5. Select the database you want MSPbots to synchronize data with in the Default database.
         
5. Click User Mapping.

   1. In the User mapped to this login section, check the database name you want to synchronize with MSPbots, for example, autotest.

   2. 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.

        
6. Click Status. 
   1. For the Permission to connect to the database engine option, check the Grant box.
   2. For the Login option, select Enabled.
      
7. Click OK to save your settings.

...