How to connect to cube using username and password?

11 posts, 0 answers
  1. Yohan
    Yohan avatar
    1 posts
    Member since:
    Oct 2013

    Posted 08 Nov 2013 Link to this post

    I am using the PivotGrid to connect to the cube. But unless I give permission to Everyone, I can’t connect to the cube using the domain account I have.

     

    Here is how I set it up:

     

    <OlapSettings ProviderType="Adomd">

        <AdomdConnectionSettings Cube="FCube"

                                 DataBase="FirstCube"

                                 ConnectionString="Data Source=XXX;Catalog=FirstCube;User Id=xxx\xxx;password=xxxx;">

         </AdomdConnectionSettings>                  

    </OlapSettings>

     

    Please let me know what I should do.

  2. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 13 Nov 2013 Link to this post

    Hello Yohan,

    Please review the answer provided in the support ticket you have opened for the same issue.

    Regards,
    Maria Ilieva
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Dick Arlbring
    Dick Arlbring avatar
    11 posts
    Member since:
    Jan 2010

    Posted 03 Jul 2014 in reply to Maria Ilieva Link to this post

    I would love to see that support ticket too, I have the same problem. 
  5. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 08 Jul 2014 Link to this post

    Hello Dick,

    Below you can see the answer provided in the mentioned support ticket:

    Thank you for contacting us.

    The problem you are facing is actually not directly related with the RadPivotGrid control but is mostly generic connectivity issue. I would suggest you to review the resources below which may help in this case:

    http://support.microsoft.com/kb/236315
    http://kb.jetreports.com/article/AA-00752/0/

    I hope this helps.

    Regards,
    Maria Ilieva
    Telerik



    Regards,
    Pavlina
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  6. Dick Arlbring
    Dick Arlbring avatar
    11 posts
    Member since:
    Jan 2010

    Posted 14 Jul 2014 Link to this post

    Hello Pavlina.

    I am able to use the identical connectionString in other connections and it's working.
    When I am the PivotGrid I am getting a error msg in RadPivotGrid1.DataProviderError:

    Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Unable to recognize the requested restriction 'CUBE_SOURCE'.

    Do you have any idea about why this error occurs?


  7. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 15 Jul 2014 Link to this post

    Hi Dick,

    It appears that this is a permission issue with your SQL Server instance and as pointed in the previous reply this is not related to the pivotgrid control. You can check the user credentials in your connection string as the issue may be there.

    Regards,
    Pavlina
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  8. Dick Arlbring
    Dick Arlbring avatar
    11 posts
    Member since:
    Jan 2010

    Posted 17 Jul 2014 in reply to Pavlina Link to this post

    Hello Pavlina!

    Like I said, I am using the same connectionString elsewhere. Not with the telerik:RadPivotGrid only using it by creating a AdomdConnection from Microsoft.AnalysisServices.AdomdClient.dll (Copy local=true).
    It leads me to believe that the PivotGrid is somehow creating the error message.

    When I am using the identity on my Application pool it's working but I need to be able to change connectionuser. That's why I want to send User id and password in the connectionString not setting a identity on the Application Pool.

    The database is using Role-based security settings.

    This is the whole error message:
    Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Unable to recognize the requested restriction 'CUBE_SOURCE'. at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IDiscoverProvider.Discover(String requestType, IDictionary restrictions, DataTable table) at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Discover(AdomdConnection connection, String requestType, ListDictionary restrictions, DataTable destinationTable, Boolean doCreate) at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.PopulateSelf() at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Microsoft.AnalysisServices.AdomdClient.IObjectCache.Populate() at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.PopulateCollection() at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.get_Count() at Microsoft.AnalysisServices.AdomdClient.CubesEnumerator.MoveNext() at Microsoft.AnalysisServices.AdomdClient.CubeCollection.Enumerator.MoveNext() at Telerik.Web.UI.PivotGrid.DataProviders.Adomd.AdomdMetadataLoader.PrepareMetadata(AdomdConnection cubeConnection, OlapCatalogInfo catalogInfo) at Telerik.Web.UI.PivotGrid.DataProviders.Adomd.AdomdMetadataLoader.ConnectAndGetMetadata() at Telerik.Web.UI.PivotGrid.DataProviders.Adomd.AdomdMetadataLoader.LoadData()






  9. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 22 Jul 2014 Link to this post

    Hi Dick,

    Could you please post your PivotGrid markup with the OLAP settings so that we could further research on your case?
    Also I would suggest you to update your application to use the latest internal build of our controls as we have made some optimizations in the OLAP binding mechanism which might give affect in your case.

    Regards,
    Maria Ilieva
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  10. Dick Arlbring
    Dick Arlbring avatar
    11 posts
    Member since:
    Jan 2010

    Posted 22 Jul 2014 in reply to Maria Ilieva Link to this post

    Hello Maria!

    This is how my PivotGrid: 

    <telerik:RadPivotGrid AllowFiltering="true" ID="RadPivotGrid1"
        RowTableLayout="Tabular" FieldsPopupSettings-AggregateFieldsMinCount="1" AllowPaging="true"
        PageSize="20" runat="server" EnableConfigurationPanel="true" EnableZoneContextMenu="true"
        AggregatesPosition="Rows" OnCellDataBound="RadPivotGrid1_CellDataBound"
        OnPivotGridBiffExporting="RadPivotGrid1_PivotGridBiffExporting"
        OnPivotGridCellExporting="RadPivotGrid1_PivotGridCellExporting">
        <FieldsPopupSettings AggregateFieldsMinCount="1"></FieldsPopupSettings>
        <PagerStyle AlwaysVisible="False" />
        <OlapSettings ProviderType="Adomd">
            <AdomdConnectionSettings
                Cube="CubeName"
                DataBase="DatabaseName"
                ConnectionString="Provider=MSOLAP.4;Data Source= Ip;Initial Catalog=CatalogName;User Id=DOMAIN\\User;password=Password;"></AdomdConnectionSettings>
        </OlapSettings>
        <ConfigurationPanelSettings Position="Top" LayoutType="Stacked" DefaultDeferedLayoutUpdate="false" />
        <ClientSettings>
            <Scrolling AllowVerticalScroll="true" ScrollHeight="600px" />
        </ClientSettings>
    </telerik:RadPivotGrid>


    I am going to try the latest internal build, I will let you know if it solved the problem. 

    Please let me know if you need anything more. 

    Regards
  11. Dick Arlbring
    Dick Arlbring avatar
    11 posts
    Member since:
    Jan 2010

    Posted 22 Jul 2014 in reply to Maria Ilieva Link to this post

    Hello!

    I have now tried using the the latest internal build, but with no luck. I am still getting the same error message as before. 
  12. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 25 Jul 2014 Link to this post

    Hello Dick,

    The connection string based on the Microsoft's best practices in this case should be set in the following format:
    Data Source=https://<;servername>/olap/msmdpump.dll; Initial Catalog=AdventureWorksDW2012; Integrated Security=Basic; User ID=XXXX; Password=XXXXX; 
     which is different than the one you are using.

    Please review the topic below and ensure that you are following the provided instructions for configuring the cube and setting its connections.

    http://msdn.microsoft.com/en-us/library/gg492140.aspx

    Regards,
    Maria Ilieva
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017