We are using Infragistics_WPF_20182a XamPivotGrid.and an AdomdConnectionSettings"XamPivotGrid.DataSource.ConnectionSettings = AdomdConnectionSettings.ConnectionString"
my question is about: when conect to a analysis services using AdomdConnectionSettings.ConnectionString and the DataSource is not a http:// but a server in this case the "User ID" parameter is ignored and it returns the error: "The user <My local user> has not access to the database"
If we connect to the server using: "Data Source=">server04:8090/.../msmdpump.dll" we have not problem.
This is the ConnectionString:
"Provider=MSOLAP.8;Password=XXX;Persist Security Info=True;User ID=XXXX;Initial Catalog=DATABASE;Data Source=server04;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Update Isolation Level=2"