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 ?

CodePudding user response：

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:

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

Now set a password as below:

Now tested in Sql database as below and it worked :

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

CodePudding user response：

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