none
Disable/delete a login in Azure SQL (Paas) RRS feed

  • Question

  • 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)
    
    

    Saturday, April 4, 2020 12:33 PM