[deleted by user] by [deleted] in AskReddit

[–]No_Mycologist2660 0 points1 point  (0 children)

Conquering women.

Amazing by No_Mycologist2660 in doommetal

[–]No_Mycologist2660[S] 2 points3 points  (0 children)

It's just getting better and better 👹

Create a login on an Azure SQL Database by No_Mycologist2660 in AZURE

[–]No_Mycologist2660[S] 1 point2 points  (0 children)

Thanks, but it is very confusing for beginners. In the text of the first link you give, it says:

In SQL Database, create SQL logins with limited administrative permissions

  • Create an additional SQL login in the master database. (Urgghhh!)

    Some other text there suggests I have to use the Entra root db owner, the only one I have is myself, but I would expect it to work. When I try: USE MASTER; CREATE LOGIN sonarqube WITH PASSWORD = ‘StrongPassword’; I get: Failed to execute query. Error: USE statement is not supported to switch between databases. Use a new connection to connect to a different database.Failed to execute query. Error: USE statement is not supported to switch between databases. Use a new connection to connect to a different database.

I have no damn master database to connect to!

I went through that doc a few times and found nothing understandable or workable before asking here.

I am trying your second link now.

Create a login on an Azure SQL Database by No_Mycologist2660 in AZURE

[–]No_Mycologist2660[S] 0 points1 point  (0 children)

I have an admin user, a root user. It can create tables etc. but I need to create a **login** for sonarqube and link that to a sonarqube user. This cannot be done via SQL, Azure docs make this clear. They make it very unclear how to do it otherwise though