Below is the BI Semantic model connection error from the windows server log. I have created a Tabular database model in Data Tools and provided administrative access to the powerpivot service account. Also, added a role membership for the same
user. In the SP 2010, when I create a new BI Semantic model connection to the tabular model residing on the SSAS Server, 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. 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)
