Hello,
I'm trying to disable/rename/delete a SQL login in Azure SQL server, but I keep getting an error as below.
The forward link takes me to a page offering to sell me an XBox. (I have literally never found a forward link that works...)
I'm logged into this instance using my domain credentials which in the same security group as the "AD admin" in Azure portal and I can certainly create logins, I just can;t do anything destructive with them.
Ok so I can create and drop new logins just not this one called "dba". This account does not have any database users mapped but if I login it seems to have access to all databases.
Any ideas?
Thanks
TITLE: Microsoft SQL Server Management Studio
------------------------------
Drop failed for Login 'dba'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot drop the login 'dba', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 15151)