How to Remove Time Keeper User ID’s from Project Cost

Subject:

The steps here describe how to remove the User ID from SQL (Database Security Users and Server Security Logins) and inactivate the employee in Project Cost.

Resolution:

Remove User ID from SQL Database Security Users.

1. Open SQL Server Management Studio (SSMS).
2. Connect to the SQL Server instance.
3. In Object Explorer, navigate to DYNAMICS | Security | Users.
4. Right-click on the SQL Server Login you wish to remove and then click Delete.
5. SSMS shows the Delete Object window.
6. Click OK.
7. In Object Explorer, navigate to Company | Security | Users.
8. Right-click on the SQL Server Login you want to drop and then click Delete.
9. SSMS shows the Delete Object window.
10. Click OK.

Remove Login from SQL Database Security Logins.

1. In Object Explorer, navigate to Security | Logins.
2. Right-click on the SQL Server Login you wish to remove and then click Delete.
3. SSMS shows the Delete Object window.
4. Click OK.

Inactive User ID in Project Cost.

1. In Dynamics GP, navigate to Project Cost | Setup | System User Setup.
2. Select the User ID.
3. Uncheck the box for all companies.
4. Click Save and close the PC System User Setup window.