In case you are not be able to drop a user from MS SQL with error ID: 15174, it means that a user is own a DB.
- Find the database this user owns with below query
SELECT name, suser_sname(owner_sid) AS DBOwner FROM sys.databases
- Change the owner of the database
- Drop the user.