Current Environment: I have been given Reader and SQL DB Contributor access to a resource group in Azure which has all the Azure SQL databases and the related Azure SQL server. I have 10 databases under the same server and within the same resource group.
Problem: When I try to connect to this server via SSMS using "Azure Active Directory - Password" I can not connect and get the "Login failed for user NT Authority\Anonymous Logon" error with error code 18456. But when I provide the database name in the connection properties in the login window of SSMS I can connect but now I can only view one database.
Question: I am trying to find out what's the reason for this behavior? As I have "SQL DB Contributor" access, shouldn't I be able to connect to the server and view all databases? Is "SQL Server Contributor" a requirement to connect to Azure SQL Server without specifying a Database name?
