Subject:

One of the most common reasons to remove a time keeper User ID from Project Cost is due to the employee being terminated.

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 a SQL Server instance.
  3. In Object Explorer, navigate to DYNAMICS | Security | Users.
  4. Right-click on the SQL Server Login you want to drop 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 want to drop and then click Delete.
  3. SSMS shows the Delete Object window.
  4. Click OK.

Inactive User ID in Project Cost.

  1. Navigate to Project Cost | Setup | System User Setup.
  2. Select a User ID.
  3. Uncheck the box for all companies.
  4. Click Save and close the PC System User Setup window.

Send this to a friend