Get a PowerPivot SSRS connection from another domain without trust relationship RRS feed

  • General discussion

  • 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.



    Wednesday, June 27, 2012 4:32 PM

All replies