SQL Server ODBC under Azure

[pdanes]

Our organization suddenly switched to some sort of cloud verification using Azure for all company notebooks, and as a result, the main Access - SQL Server app that everyone uses is suddenly inaccessible.

All standard desk mechines use Win 10 under a normal domain controller, and all there remains perfectly functional. But all notebooks now run Win 11, with this Azure business, whatever that means, and none of those work, at all. I cannot access network shares, I cannot connect using ODBC, and none of my VBA calls to get domain group memberships return anything. Nobody in the organization knows anything, including a tech supposedly imported directly from Microsoft to help deal with just this sort of stuff. They did no pre-release analyis, or prepared instructions, just implemented it, and left us to fend for ourselves.

Does anyone have any experience with this, and what is needed to get all this crap functional again? I can't even find anything on the net that would get me started in the right direction.

[Minty]

They might be using in-built Azure Authentication, which apparently these days is called Entra ?
https://learn.microsoft.com/en-us/az...authentication

But I think you are gong to need a steer from the suppliers, as I am guessing.

[pdanes]

They might be using in-built Azure Authentication, which apparently these days is called Entra ?
https://learn.microsoft.com/en-us/az...authentication

But I think you are gong to need a steer from the suppliers, as I am guessing.

Which suppliers? If you mean the authors of the database, that is me - sole author. I am the one who can't get this to work.

[Minty]

I meant your IT support or external resource if it's out-sourced

[pdanes]

I meant your IT support or external resource if it's out-sourced

Well, thanks, but as I wrote in the original post, nobody in the institution knows anything about this. Naturally, that was the first thing I tried, after finding out they implemented this, and zero, again, including a supposed expert from Microsoft who was brought in specifically for this kind of thing. They're not being jerks, but they just don't know anything about it all, which is the reason why I tried here.

[Minty]

I can't tell from your OP, but have you tried setting up a new ODBC connection from the new machines to the SQL server, independent of Access?
It might give you some hints about what type of credentials it is after?

There is an option to use Azure authentication : https://learn.microsoft.com/en-us/sq...l-server-ver16

[pdanes]

I can't tell from your OP, but have you tried setting up a new ODBC connection from the new machines to the SQL server, independent of Access?
It might give you some hints about what type of credentials it is after?

There is an option to use Azure authentication : https://learn.microsoft.com/en-us/sq...l-server-ver16

Yes, I did try that. Side by side, exactly the same ODBC setup procedure on a Win 10 machine with the old domain controller and a Win 11 machine with this Azure stuff. The 10 machine connects normally, the 11 machine says connection test failed. No details.

I'll try that Azure authentication business Monday, thanks, but at first glance, it looks awfully complicated. And there is a lot on these notebooks that I can't do at all, because they have tightened up the security protocols to the point where it is almost impossible to do anything but documents and email.