How to resolve Azure “Windows logins are not supported in this version of SQL Server”?

Question

right now I am working on a project with .Net CORE c# and entity framework database and I get an error

SqlException: Windows logins are not supported in this version of SQL Server.

I followed a tutorial and I think I did everything fine... The only difference is that I have my database hosted on Azure, it should matters?

Here is my connection string

"DefaultConnection": "Server=firstdb123.database.windows.net;Database=TestDB;Trusted_Connection=True;MultipleActiveResultSets=true",

Here is a picture with my database

I have my EmployeesController and my EmployeeContext made by visual studio so it should be right.. but I don't know why it dose not work

Any help would be awesome

Answer 1

See that Trusted_Connection=True; bit in your your connection string? That's a Windows shortcut that allows you to bypass the normal username/password credentials on a server.

You need to create secure Azure login, then use that to specify the connection string.

This page shows how a connection string is created in the various different SQL version.