Analysis Service Connection Error from Dashboard Designer RRS feed

  • Question

  • Below is the error when trying to connect to analysis service from dasboard designer.

    The Unattended Service Account "DomainName\USER" does not have access to the following data source server.

    Data source location: http://sharepoint:5000/sites/BI/Data Connections for PerformancePoint/12_.000
    Data source name: New Data Source 
    Server name: SQL

    Exception details:
    Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
       at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
       --- End of inner exception stack trace ---
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
       at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
       at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
       at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
       at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.AdomdConnectionPool`1.<>c__DisplayClass2.<GetConnection>b__0()
       at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
       at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
       at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
       at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
       at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.AdomdConnectionPool`1.GetConnection(String connectionString, ConnectionContext connectionCtx, String effectiveUserName, CultureInfo culture, NewConnectionHandler newConnectionHandler, TestConnectionHandler testConnectionHandler)

    Tuesday, March 12, 2013 1:23 PM


  • I solved this issue.

    In SQL Server Browser service, TCP port 2382 was blocked for Analysis Services. To unblock this

    1. On Windows 7 or Windows Vista, in Control Panel, click System and Security, select Windows Firewall, and then click Advanced settings. On Windows Server 2008 or 2008 R2, open Administrator Tools and click Windows Firewall with Advanced Security.
    2. To unblock access to SQL Server Browser service, right-click Inbound Rules and select New Rule.
    3. In Rule Type, click Port and then click Next.
    4. In Protocol and Ports, select TCP and then type 2382 in Specific local ports.
    5. In Action, click Allow the connection and then click Next.
    6. In Profile, clear any network locations that do not apply and then click Next.
    7. In Name, type a descriptive name for this rule (for example, SQL Server Browser Service (tcp-in) 2382), and then click Finish. 

    Thursday, March 14, 2013 12:01 PM