Authentication with Entra ID?

[tsoernes]

Is it possible to connect to a database and authenticate with Microsoft Entra ID?

[Fuco1]

I wrote a small function for myself to do that. I would guess you can also use other types of logins, change AUTHENTICATION appropriately.

(defun my-lsp-mssql-connect ()
      (interactive)
      (lsp)
      (lsp-mssql-connect
       (list
        :server (swb--get-default-host)
        :connectionString
        (format "SERVER=%s;DATABASE=%s;UID=%s;PWD=%s;AUTHENTICATION=ActiveDirectoryServicePrincipal"
               ;;; somehow fill these values in, `swb` is my own personal internal functions to get credentials.
                (swb--get-default-host)
                (swb--get-default-database)
                (swb--get-default-user)
                (swb--get-default-password)))))