Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Cristina López
15
Binding XamPivotGrid to Analisis analysis services using User ID without IIS
posted

We are using Infragistics_WPF_20182
a 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"