Hi,
I am trying to connect to an olap cube where the IIS olap website is setup with basic authentication.
The xaml is as follows:
-------------------------------------------------------------------
<navigation:Page x:Class="CFSapp.Views.PivotGrid"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
mc:Ignorable="d"
xmlns:navigation="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Navigation"
d:DesignWidth="640" d:DesignHeight="480"
Title="PivotGrid Page" xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk"
xmlns:ig="http://schemas.infragistics.com/xaml">
<Grid x:Name="LayoutRoot">
<ig:XamPivotDataSelector HorizontalAlignment="Right" Margin="0,25,0,0" Name="dataSelector" VerticalAlignment="Top" />
</Grid>
</navigation:Page>
-----------------------------------------------------------------------------
and the code behind is as follows:
XmlaDataSource xmlaDataSource1 = new XmlaDataSource();
xmlaDataSource1.ServerUri = new Uri(https://remotewebsite/olap/msmdpump.dll);
xmlaDataSource1.Credentials = new XmlaNetworkCredential("username", "password","domain");
this.dataSelector.DataSource = xmlaDataSource1;
________________________________________
When i open the page I get a login box to connect to the "remotewebsite", so I enter the credentials again, but the data selector does not get connected.
Using the same address and credentials, I can connect to "remotewebsite" with Excel pivot. I can also connect to infragistic sampledata by changing the URI and removing the xmlaDataSource1.Credentials = new XmlaNetworkCredential("username", "password","domain"); line from the code behind.
Any clue how to connect to my olap database which is setup with basic authentication?
PS: I am using the assemblies from InfragisticsSL4.v10.3
Cheers,
Oyvind
Just want to add that I am using the Trial version of the component.
Can you try to set the credentials before set the ServerUri. Setting the ServerUri will create the default XmlaDataProvider for you using the current credentials of XmlaDataSource. That's why you need to set the credentials first.Let me know if that works for you.
Regards.Plamen.
No, it didn't help. It still can't connect to the AS database. Any other tips or suggestions?
I'm having the same issue. My pump is using basic in IIS 6. When I do not pass the credentails and login it works. Pump is working fine, but when I pass credentails it does not connect. Am I missing something? Here's my connection:
XmlaNetworkCredential
{
Password =
,
UserName =
Domain =
"domain"
};
);
XmlaDataSource
Credentials = cred,
ServerUri = uri
pivotGrid.DataSource = OlapSource;
dataSelector.DataSource = OlapSource;
Hello,
Does your “domain\testuser” exist in membership users list for any of roles of your database? When you make anonymous call the connection is established with specific user credentials set for Anonymous Authentication, let say it’s IUSR. Besides IUSR, used for anonymous calls, you have to add in membership list the users that have access to the database in other authentication modes. Don’t set domain in your XmlaNetworkCredential if you are using Digest Authentication.
Best regards.Plamen.
Perfect. It works. I had mine set to:
<allow-from http-request-headers="SOAPAction">
Thanks for the help!
Ok, now I think I’ve located the problem. I think you have to change your clientaccesspolicy.xml to accepts any headers because the credentials are send as authenticate header.
<allow-from http-request-headers="*">
<domain uri="*"/>
</allow-from>
Try it and let me know if it works.
Regards.
Plamen.
Just tried that and still does work.
Can you try to set ServerUri first and then the Credentials property
We have the roles correctly set up in SSAS. The pump is working fine. I can connect through Excel and through my app with the XamlPivotGrid and expandeer controls. IIS is set to basic and the dialog box comes up and can connect fine when I do not pass the credentails. As soon as I set the credentials with the code above, it will not connect.