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

Click Company admins / SQL Logins > Delete SQL Server Logins.
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.
Click [Update sysadmins].

More resources

For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.

For additional training on Sage products, visit Sage University.