question

MichaelMacGregor-8896 avatar image
0 Votes"
MichaelMacGregor-8896 asked MichaelMacGregor-8223 commented

Cannot drop a login/user from Azure SQL Database

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

azure-sql-database
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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?

0 Votes 0 ·

@MichaelMacGregor-8896 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

0 Votes 0 ·

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

0 Votes 0 ·

The login I am trying to delete is a SQL login, and my account is specified as the server admin and is AAD.

0 Votes 0 ·

0 Answers