Microsoft Entra Authentication

trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool

MIT License

257 stars 60 forks source link

Microsoft Entra Authentication #847

Closed EpitomeOfDeath closed 2 weeks ago

EpitomeOfDeath commented 6 months ago

We use Microsoft Entra Authentication for our Azure Elastic pool Dbs. There is no option for this in login form.

DavidWiseman commented 6 months ago

Hi, you can enter a connection string in the source textbox instead of using the Connect dialog to build the connection string. I think this will allow you to use Entra. DBA Dash is using the latest SqlClient so it should support this. This link has some connection string examples.

Let me know if it works.

jacobgexigo commented 5 months ago

It would be nice to have the configuration GUI allow for the selection of "Microsoft Entra ID with MFA" in the drop down, so we can put in the EID user name and then it would do the normal browser pop to allow the password and MFA for getting the token. I think this is OAuth.

DavidWiseman commented 5 months ago

I'd like to provide support for this. I don't have a way to test it at the moment so I'll need to set something up so I can play about with it. It's not high priority for me but I am interested in looking at it when I get time.

rgrwilloughby commented 3 months ago

We have this working

We used the command line DBADashConfig -c to set them up

example connection string below - we've given the VM running the DBA dash server an MS Entra managed identity and then granted that required access on Azure SQL Servers we want to monitor

"ConnectionString": "Data Source=***********.database.windows.net;Encrypt=True;Trust Server Certificate=True;Authentication=ActiveDirectoryManagedIdentity;Application Name=DBADash",

DavidWiseman commented 2 weeks ago

New connection dialog coming soon...

DavidWiseman commented 2 weeks ago

Included in 3.10 🚀