Deleting a SQL Server Login

If an employee leaves your company, use the Delete SQL Server Logins tab to remove all access to the SQL Server instance for that employee.

Important! After you delete a user's SQL Server login, they can no longer sign in to any Sage 100 Contractorcompany.

If you need to remove a user's access rights to one company, while maintaining their access to other companies, remove the user from the 7-2-2 User List for the company in Sage 100 Contractor.

To delete a SQL Server login:

  1. Click Company admins / SQL Logins > Delete SQL Server Logins.
  2. On the list of users:
    • Select the check box for each user you want to delete from the SQL Server database.
    • Clear the check box for users whose access to the SQL Server database you want to maintain.
  3. Click [Update sysadmins].