Page History

...

1. Log in to SQL Server Management Studio and right-click on Logins. 
   Image AddedImage Removed
   
2. On the Login Properties - Newmspbots window, type mspbots mspsqlagent on the field for Login name and select the SQL Server authentication radio button. 
3. Enter and confirm the Password,and tick the checkboxes for Enforce password policy and Enforce password expiration.
   Image RemovedImage Added 
4. Next, go to Server Roles and tick the checkboxes for public and sysadmin.
   Image Removed Move on to User Mapping. Put a checkmark on the autotest checkbox under the Database column. Then in the table below it, Select the database that you want to synchronize and put checkmarks on the checkboxes for db_datareader and public.
    
5. Next, go to Securables > Permissions for <user>. Tick the Grant checkbox for View any definition.
   Image Removed 
6. LastlyThen, go to Status > Settings. Select Open the account by selecting the radio buttons for Grant under Permission to connect to database engine, and Enabled under Login.
7. Click OK to save the settings. 

...