Authenticating from domain 'X' PC towards domain 'Y' Azure SQL

[IT ProActive]

Hi, 

I have a small question that I was hoping you could assist with.

Here's the scenario as we see it:

We're considering creating an Azure SQL database on domain YYYY's Azure tenant, but on our local PC's are logged into domain XXXX.

We've tested with the following:
- Integrated Windows authentication (We did not expect this to work and it didn't)
- Reading over the Forums, we found that the suggestion is often to set up a Full Trust between the two domains, but that will NEVER be an option for us. 
- RunAs does not work either 

However, we are wondering if we can use Azure AD to authentication our users with?

Looking over some other tools, we've seen that it works with those. 

Any help would be greatly appreciated.