ryebreadnyc, 12 days ago

@danwwilson @hrbrmstr I recently had a colleague reach out to my team for helping doing the same thing. I found some MSFT docs on how to do it but I haven’t had a chance to play/proof of concept any code yet. I’ll link the docs I found when I’m on the work pc later today

danwwilson, 12 days ago

@ryebreadnyc Thanks, my issue at the moment is that r is having problems finding ODBC.so. Search results are not particularly helpful on this front. 😔

Cmastication, 12 days ago

@danwwilson @ryebreadnyc you in Linux?

danwwilson, 12 days ago

@Cmastication @ryebreadnyc Intel Mac.

Cmastication, 12 days ago

@danwwilson @ryebreadnyc in unixodbc installed and tested?

odbcinst -j

Then use isql to test a connection?

Cmastication, 12 days ago

@danwwilson @ryebreadnyc I feel your pain. I fight something related to this every year or two

danwwilson, 12 days ago

@Cmastication @ryebreadnyc So I just updated to the dev version of r-dbi/ODBC and that error message is gone. Can confirm that unixodbc is there and am struggling with isql as much as anything because of the MSFT entra auth.

Cmastication, 12 days ago

@danwwilson @ryebreadnyc I have zero experience with entra auth. So this territory is uncharted by me :(

Cmastication, 12 days ago

@danwwilson @ryebreadnyc you got the msft odbc driver installed and configured appropriate odbcinst.ini?

Entry like:

[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/usr/local/lib/libmsodbcsql.17.dylib
UsageCount=1

Cmastication, 12 days ago

@danwwilson @ryebreadnyc then for auth are you using uid & pwd or a token?

danwwilson, 12 days ago

@Cmastication @ryebreadnyc uid & pwd

Cmastication, 12 days ago

@danwwilson @ryebreadnyc good. I’m 0 for 8 on attempts to use tokens outside of windows.

Cmastication, 12 days ago

@danwwilson @ryebreadnyc odbc.ini all set up?

Authentication=SqlPassword
UID=your_username
PWD=your_password

Cmastication, 12 days ago

@danwwilson @ryebreadnyc that’s in addition to the normal incantations:

[MyMSSQLDB]
Driver=ODBC Driver 17 for SQL Server
Server=tcp:your_server.database.windows.net,1433
Database=your_database_name
Trusted_Connection=no
Encrypt=yes

hrbrmstr, 12 days ago

@Cmastication @danwwilson @ryebreadnyc from digesting the docs this morning, i'm pretty sure you need to be on windows for this to work.

Cmastication, 12 days ago

@hrbrmstr @danwwilson @ryebreadnyc even with UID and PWD? I had drawn that conclusion wrt tokens.

hrbrmstr, 12 days ago

@Cmastication @danwwilson @ryebreadnyc It may depend on the twisty maze of supported settings in the instance.

Pplx says this tho (the links it surfaced seem like good resources too) https://www.perplexity.ai/search/how-can-i-My0C5KRAQQC1ILy5tfTElg

hrbrmstr, 12 days ago

@Cmastication @danwwilson @ryebreadnyc I rly have to start asking pplx first just to save time Kagi'ing links

danwwilson, 12 days ago

@Cmastication @ryebreadnyc Would like to be in Linux but I have to use a clients ‘sonicwall’ vpn which doesn’t seem to have a Linux cli option. 🤷‍♂️ go figure.

hrbrmstr, 12 days ago

@danwwilson @Cmastication @ryebreadnyc that client doesn’t support NetExtender? https://www.sonicwall.com/products/remote-access/vpn-clients/#:~:text=VPN%20Client%20(GVC)-,NetExtender,and%20access%20resources%20as%20if%20they%20were%20on%20the%20local%20network.,-Compatible%20Devices

hrbrmstr, 12 days ago

@danwwilson I avoid that ecosystem like folks used to avoid plagues.

These may help tho.

https://github.com/MicrosoftDocs/sql-docs/blob/live/azure-sql/database/authentication-azure-ad-only-authentication.md

https://svrooij.io/2024/03/27/azure-sql-entra-id-tips/

https://powerusers.microsoft.com/t5/Power-Apps-Governance-and/Connecting-to-Azure-SQL-Database-using-Entra-ID-authentication/m-p/2551624#M10975

https://www.trendmicro.com/cloudoneconformity/knowledge-base/azure/Sql/microsoft-entra-admin.html