Cannot set the initialization properties for OLE DB provider “MSOLAP” for linked server, Double Hop Authentication

Ohhh… Well the above words can only describe the pain which I encountered again on a different combination of multi server components authentication of MSBI using windows authentication. Well the set up, I worked with is as follows: So as it goes, I had a chart on SSRS, which sources the data from the SQL Read More …