Scenario

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.

Solution

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.

Syntax

  • Open Command Line tool
  • Enter runas /netonly /user:<domain>\<user> <Path to the client application>
  • Enter password

Example

I want to connect to SSAS from my local machine using SSMS. SSAS is hosted on 20.20.1.1 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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s