I’m developing an C# OLAP Action that connects to a webservice using WebClient class. The idea is to pass current user’s Windows credentials to this webservice. To do it, I need to set “Use the credentials of the current user” in Impersonation Information of the Action. But passing Windows credentials with those lines:
wc.UseDefaultCredentials = true; wc.Credentials = System.Net.CredentialCache.DefaultCredentials;
doesn’t work, as when trying to read, webservice returns 401 – Unauthorized error.
BUT, when I change Impersonation option to “Use a specific Windows user name and password” and put the exact domain, username and password of user that I’m using, it works. So there’s probably a problem between Windows and SSAS service that prevents the latter of obtaining current user’s credentials. Any idea how to fix this?