The parameter password cannot be provided for users that cannot authenticate in a database.

I got this error while running the script to manage users.

Solution

My mistake was I had not created the user properly in my Azure SQL database server.

To fix this error, you must ensure that you have done it properly while creating a user in the Azure SQL database server.

It would be best if you will use the below query to create the user

CREATE LOGIN xyz 
WITH PASSWORD = 'Abc@1234' 

After executing the above query, the user will be created successfully. Check out the screenshot below.

If you don’t properly create the user, then there is a chance that you will get this error.

Rajkishore

I am Rajkishore, and I am a Microsoft Certified IT Consultant. I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machines, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.