H0576.AddIndicator_2D00_2.png"/resized-image.ashx/__size/550x0/__key/CommunityServer-Components-UserFiles/00-00-00-24-16-Attached+Files/3125.AddIndicator_2D00_1.png" border="0" />
But if I try to do that from any other server, it fails with this error (it appears right after I click Add indicators):
An unexpected error occurred while processing the Business overview Web part. Contact your system adminstrator.
The EventLog on the PORTAL server records the following error at this time:
An unexpected error has occurred.
A connection cannot be made. Ensure that the server is running.
Microsoft.AnalysisServices.ConnectionException
at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.WebParts.CubeHelper.IsFiscalDateDimension(String dimensionName, String cubeName, AdomdConnection connection)
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.WebParts.BusinessOverviewWebPart.PopulateListWithTimePeriods(ArrayList list, Dimension dimension, String cubeName)
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.WebParts.BusinessOverviewWebPart.CubeChanged(String args)
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.WebParts.BusinessOverviewWebPart.RaiseCallbackEvent(String eventArgument)
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
System.IO.IOException
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.TcpStream.GetResponseDataType()
An existing connection was forcibly closed by the remote host
System.Net.Sockets.SocketException
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
Also, in the SSAS Flight Recorder, I found logon attempts with ANONYMOUS LOGON at the same time. It looks like a connection is first made using business connector account (which is the account running the application pool on the IIS), and then the web part is trying to connect to the OLAP database using anonymous logon and fails (rather expectedly).
Does anyone have any idea how to resolve this?
Any help is highly appreciated. Thank you!
