Delete a User from SQL

To delete a user at the database level:

  1. Open Server Management Studio (SSMS).

    The Connect to Server window displays.

  2. Enter the following Server details:
    • Server type
    • Server name
    • Select the Authentication method. If required, enter your login credentials.
  3. Enter the following Connection Security details:
    1. Select the Encryption type.
    2. Select whether to Trust server certificate.
    3. If Strict is selected as the Encryption type, enter the Host name in certificate.
  4. Click Connect.

    The nodes for the database display in the Object Explorer window.

  5. Expand the Databases node.
  6. Select and expand the database you want to delete the user from.
  7. Expand the Security folder in the selected database's node.
  8. Expand the Users folder.
  9. Right-click on the user you want to delete and select Delete from the menu.

    The Delete Object window displays.

  10. Select the Object to be deleted.
  11. Click OK.

To delete a user at the SQL server level:

Note: Deleting a user with this method removes their access to the SQL Server and the specific database.

  1. Open Server Management Studio (SSMS).

    The Connect to Server window displays.

  2. Enter the following Server details:
    • Server type
    • Server name
    • Select the Authentication method. If required, enter your login credentials.
  3. Enter the following Connection Security details:
    1. Select the Encryption type.
    2. Select whether to Trust server certificate.
    3. If Strict is selected as the Encryption type, enter the Host name in certificate.
  4. Click Connect.

    The nodes for the database display in the Object Explorer window.

  5. Expand the Security folder.
  6. Expand the Logins folder.
  7. Right-click on the user you want to delete and select Delete from the menu.

    The Delete Object window displays.

  8. Select the Object to be deleted.
  9. Click OK.