SQL Azure Connection

Question

I cannot connect to my DB SQL Azure through SQL Management Server, I use this type of connection (user is my user of Azure Portal), where is the error?

Server type: Database Engine
Server name: as copied by th Azure (xxx.database.windows.net)
Authentication: Azure Active Directory - Password
User name: e-mail used for accessing Azure portal
Password: password accessing Azure portal

Thanks

Answer 1

Yes, the problem is that. I set the administrator (see attached) and then I try to enter from SSMS. It doesn't work for any of these 3 ways, where is the error?

1. I'm using as "account" the name of the Azure account (cicerone.diamond.xxx) and the password of Azure Portal
2. I have also used as account the ID of Administrator created
3. I have also tried to enter wit "universal MFA", but it gives me an error (see attached)

Thanks for your help

Answer 2

I wonder, if its not allowing you to login - because your gmail address is classified as an external address - to Azure AD. Try to create a native Azure AD user, add that to the SQL Admin groups and login using that.

Note: Make sure you login using hat accounts username and password into 'portal.azure.com' so you can set MFA and change the password, if required - before logging into SQL Management Studio.

Answer 3

@GS Can you confirm if you have a network connection by default for the Public network access setting is disabled. you can choose to connect to a database by using either public endpoints or private endpoints,

if you already have this setup can you try connecting from the Query editor as shown below

Regards
Geetha

Answer 4

In no way it works! I recap (I'm coming from Oracle Cloud and the first impression are not good...I hope it's only my few experience..).

I have followed this steps (I attach the various printscreen):

1. I open a SQL Server istance on Azure, then I add an Administrator (specific for SQL Database)
2. Then I open a SQL Azure Database and I read the name of Cloud Administrator (itinerarium.xxx)
3. Then I move to SSMS and I insert data for entry, but I get an error, all these cases:
   a. SQL authentication with user of Administrator
   b. Azure Active Directory with user of Administrator reported in Azure Active Directory
   c. Azure Active Directory with user equal to the user I use for login into Azzure

In all cases, I used the password used to enter into Azure Cloud.

Where is the error?

Thanks

Answer 5

Solved!!

Using Cloud Administrator Password works...I reset the password and retry...no it's ok