SQL Server Analysis Service (SSAS) supports only Window Authentication mode. If you want to connect SSAS remotely from your local machine using some client tools such as SQL Server Management Studio (SSMS), Tableau or others… you will encounter an issue of connecting to SSAS.
This is because these tools run under you local account when you open them directly. For example, I logged into my local machine under DUNGDT\dungdt accout and then opened SQL Server Management Studio. It means that SSMS was been running under DUNGDT\dungdt account. I tried to connect to SSAS in remote server, it was failed because SSAS did not authenticated DUNGDT\dungdt account.
The prerequisite condition, you must have VPN connection to join the domain of SSAS server that SSAS is hosted or trusted domain at least. Your VPN account must have permission to access SSAS. Then using runas statement to open the client tools from your local machine.
- Open Command Line tool
- Enter runas /netonly /user:<domain>\<user> <Path to the client application>
- Enter password
I want to connect to SSAS from my local machine using SSMS. SSAS is hosted on 22.214.171.124 machine and domain is BI-INDEX
- Connect VPN to join BI-INDEX under BI-INDEX\dungdinh
- Use runs statement to open SSMS
- runas /netonly /user:BI-INDEX\dungdinh “C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\ssms.exe”
- SSMS is run under BI-INDEX\dungdinh account and I am able to connect SSAS although you still see DUNGDT\dungdinh account on SSMS