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 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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.