BI Semantic Model connection issue against a PowerPivot excel RRS feed

  • Question

  • Below is the BI Semantic model connection error from the windows server log. I deployed the Powerpivot excel to the Sharepoint powerpivot gallery. In the SP 2010, when I create a new BI Semantic model connection on Power Pivot excel, I m getting the following error. I have spent lot of time debugging the issue with no luck.

    My ultimate goal is to create a power view report based on the semantic model connection on PowerPivot excel. Please advice.

    EXCEPTION: Microsoft.AnalysisServices.OperationException:
    The following system error occurred:  Logon failure: unknown user name or
    bad password.        at
    Microsoft.AnalysisServices.XmlaClient.CheckForSoapFault(XmlReader reader,
    XmlaResult xmlaResult, Boolean throwIfError)     at
    Microsoft.AnalysisServices.XmlaClient.CheckForError(XmlReader reader,
    XmlaResult xmlaResult, Boolean throwIfError)     at
    Microsoft.AnalysisServices.XmlaClient.CreateSession(ListDictionary properties,
    Boolean sendNamespaceCompatibility)     at
    Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo,
    Boolean beginSession)     at
    Microsoft.AnalysisServices.Server.Connect(String connectionString, String
    sessionId)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplication.ValidateLinkFileConnection(String
    serverName, String dbName, String username)

    Tuesday, February 7, 2012 4:40 PM

All replies