SQL Server Error: The database principal owns a service in the database, and cannot be dropped

There are two options here.

1. You map orphan user to login if user is required.  sp_change_users_login

2. Run below code and check which service user owns.

select s.name as ServiceName
from    sys.database_principals p 
        inner join sys.services s on p.principal_id = s.principal_id 
where p.name = 'nimit' --User Name (which you trying to delete)

It will give you list of Services Owned by that User. Now to remove this dependancy you have to ALTER SERVICE AUTHORIZATION by running below query. If there are multiple services than run below code for all services.

--Here nimit is the ServiceName I got from above query
ALTER AUTHORIZATION ON Service::nimit TO [dbo] --Transfer Service Authorization to dbo

For e.g.

select s.name as ServiceName
from sys.database_principals p 
inner join sys.services s on p.principal_id = s.principal_id 
where p.name = 'um_user' 

select * from sys.database_principals p 

select * from sys.services 
select * from UrgentMessenger_MP.sys.services 

use UrgentMessenger_MP;
ALTER AUTHORIZATION ON Service::[SqlQueryNotificationService-7900eee3-6002-43d9-9e3f-a6e4633d2fe2] TO [dbo]