sqlserver can't use interactive auth

[SCantergiani]

Hi guys

Would appreciate some help.

I'm trying to use browser auth for mssql. I omitted the user and password as is stated in the documentation, but I'm still getting this error:

This is my URL structure.

"sqlserver://<server>:<port>/<database>?authentication=ActiveDirectoryInteractive"

What am I doing wrong?

[kristijanhusak]

Can you try without the vim-dadbod-ui plugin?

[SCantergiani]

@kristijanhusak thanks for the quick response.

Can you try without the vim-dadbod-ui plugin?

So I uninstalled the UI and completion plugin, and I've tried doing :DB sqlserver://<server>:<port>/<database>?authentication=ActiveDirectoryInteractive and still getting the error:

[tpope]

How would you do this from the command line with sqlcmd?

[SCantergiani]

How would you do this from the command line with sqlcmd?

So using sqlcmd I can do az login and then sqlcmd -S tcp:<server>,<port> -d <database> -G

[tpope]

Is that go-sqlcmd? Per #152, I think the plan was to favor go-sqlcmd going forward.

Separate question: Does #187 fix it?

[SCantergiani]

Is that go-sqlcmd? Per #152, I think the plan was to favor go-sqlcmd going forward.

Separate question: Does #187 fix it?

Hi @tpope, appreciate the help.

I believe is go-sqlcmd that uses the same command. https://github.com/microsoft/go-sqlcmd

Regarding #187, I’ve replaced the file, and it kinda works now. I get the browser popup, but it does each time I do an action, instead of only once at the beginning (just like someone stated here #152). However, replacing the file and switching from authentication=ActiveDirectoryInteractive to authentication=ActiveDirectoryDefault does work.