Analysis Services Double Hop Authentication
Recently we had a problem with Analysis Services double hop authentication. Thanks to the uber DBA guy here we were able to find a solution.
Thought I would share his write up (he spent a lot of time searching out a solution).
As you know we have run into a problem with querying Analysis Services from another computer (our desktops for example) after connecting to a secondary server.
After working on this case with MS, we have an understanding of the problem and we have a solution.
Tags: security