Get a PowerPivot SSRS connection from another domain without trust relationship

Question

Hi all,



I'm pretty new in PowerPivot's world and  blocked with an authentification problem.



First, I used to connect to my cube through Excel and ODBC connection, it works without built-in Windows authentication, I need to put my username and password in the definition string (connection's properties windows).

Here my connection string :

Provider=MSOLAP.4;Password=myPasswordHere;Persist Security Info=True;
User ID=MYDISTANTDOMAIN\myUserName;Initial Catalog=MyCatalogNameHere;Data Source=xxx.xxx.xxx.xxx:xx;
Location=xxx.xxx.xxx.xxx:xx;MDX Compatibility=1;Safety Options=2;
MDX Missing Member Mode=Error

It's wonderfull with Excel but, when i tried to configure PowerPivot with this connection properties i got a successfull connection test message and then an error message :

I already tried to configure the connection by myself without the .odc file by entering all informations but there is no way, it doesn't work.

I have to say that i can't modify anything within the relationships between domains.

Thanks for help.

Regards

 

Answer 1

A little up :)