Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Azure SQL Database Authentication

I believe that I've looked at all the posts on this but I can't find my answer. Sorry if it's already covered.   What is the best authentication method for accessing an Azure SQL database from the ...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-jiascu-msft

 

That's what we're working towards. We have set up a service account on our network and that is now linked to an Office 365 account. So I'm trying to use [email protected] to access the data. We know that it works because we've logged in using SSMS and it is successful.

 

At the screen below, when I enter the service account details it always defaults back to my credentials.

 

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Seems good in my test. Though it shows the "Windows" authentication, I still can refresh. I will check out tomorrow to see if there are any issues. 

 

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Brilliant, thank you. It could be how we've provisioned the accounts in the background.

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

      The refresh seems fine. That means the credential is stored successfully. I consulted the Product team. I will share it with you when I get the answer.

       

      Best Regards,

      Dale

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous,

         

        This is by design. The filed will be reset when the auth dialog is loaded.

         

         

        Best Regards,
        Dale