We have a company we recently acquired and we would like for them to access our SQL Server Analysis Services (via Excel file) on our company's domain. They are external users with separate Windows domains.
I was reading about AD Forest trusts and I don't know if this is the right path. If we set up a trust relationship between the two domains, can I add NewCompany\NewUser to our SSAS security role and they would have access?
It seems like if they're in Azure, following the below would work? https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/identity/adds-forest
The end result I want is:
- for NewCompany\NewUser to refresh the cube/PivotTable in Excel on their PC without having to VPN (this is the key thing)
- edit: Using a jumpbox would be ok too.
Is this possible and if so, is there a high-level overview of the steps needed? Would I be able to add NewCompany\Sam to SSAS security role, for example?
I'm a software developer so don't know much about infrasture/AD. This is mainly for my curiosity - I don't think we'll implement this. Thanks!
My company uses Windows Server 2016. New company uses Azure AD Services.