Question 104444 in Azure Question posted in
The official documentation to get you started can be found here.

Why I am I getting only azure active direcoty authintication is enabled when trying to connect azure aql server?

I have created azure sql server machine in azure portal.

While creating the machine I for got to add sql server authintication.

So Now When I try to login,Only azure active direcoty authintication is enabled.

How Can I fix that ?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Sloved it by az sql server ad-only-auth disable --resource-group mygroup --name myServer


  2. 0

    I have reproduced in my environment and Got expected results as below:

    • Firstly, I have created a SQL server with Ad authentication.
    • Then Opened SQL Server in Portal
    • Then click on settings Section
    • Then click on Azure Active directory and then unselect Azure active directory authentication only and then save it as below:

    enter image description here

    Then Click on Overview of SQL Server and Click on Reset password as below:

    enter image description here

    Now set a password as below:

    enter image description here

    Now tested in Sql database as below and it worked :

    enter image description here

    Try to follow above process to change the authentication mode as mine got changed.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search