Cannot drop a login/user from Azure SQL Database

Michael MacGregor 6

I am the server admin for the Azure SQL Database server, but when I attempt to drop a login/user I get the following error:

Cannot drop the user 'username', because it does not exists or you do not have permission.

How do I resolve this? The login/user belongs to someone who is no longer with the company and I need to get rid of it.

TIA

Michael MacGregor
Database Architect

Nandan Hegde 32,026 Reputation points MVP

2021-06-08T02:47:39.083+00:00

Hey,
Can you tell whether the login you are trying to delete is a SQL login or an AD login?
And from which auth have you logged in ?
Whether AD AUTH or SQL auth?
Michael MacGregor 6 Reputation points

2021-06-08T02:49:26.227+00:00

The login I am trying to delete is a SQL login, and my account is specified as the server admin and is AAD.
Oury Ba-MSFT 18,776 Reputation points Microsoft Employee

2021-06-16T18:23:05+00:00

@Michael MacGregor Could you please raise a support ticket. There must be something we need to look at very closer.
Please do share the ticket number so we can keep track.
Regards,
Thanks
Michael MacGregor 86 Reputation points

2021-06-16T18:28:37.383+00:00

There's no need. The restriction is due to the fact that the account is the owner of the server on which the database resides, so it can't be changed. If you want to add a wishlist request it would be to allow the server admin to be changed.
There are many more items I could add to a wishlist for Azure SQL Database, such as being able to see the roles that users/logins are members of in SSMS the same way they can be seen for an on-premise SQL Server or SQL Server on an Azure VM. SSMS for Azure SQL Database definitely took a few steps backwards. Azure Studio isn't any better.

Regards,

Michael MacGregor
Database Architect

Your answer