How to login the SQL server authentication?

Question

I can only access my database via the SQL Database Query Editor via the "Microsoft Extra Authentication". I tried logging in using the "SQL server authentication" but that doesn't allow me to do so. Question: Where do I generate or obtain that login/password? Thanks.

Answer 1

if your sqlserver uses Entra (azure ad) authentication, then the users are defined in Entra tenant the sqlserver is enrolled. only someone defined as sql admin can define users. typically you would use security group, but individual existing Entra accounts can be add to the sqlserver.

when the database was configured an Entra user/group was defined as admin. then Entra groups should ave been dined and given roles in the database. you will need to contact the admin group to know what Entra groups your Entra account should be added to.

Answer 2

Hi @Brian Thomas,

You may need to use an account which has permission to change the server authentication mode.

And then you may use SQL server authentication.

Change server authentication mode

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.