Cant't connect to Analysis Server from PerformancePoint Services Dashboard Designer: SocketException: The requested name is valid, but no data of the requested type was found RRS feed

  • Question

  • Problem:

    Everytime I try to create a data connection in the Performance Point Services dashboard designer, following message is shown in the event log:

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

    Data source location: http://SHAREPOINT/bicenter/Data Connections for PerformancePoint/11_.000
    Data source name: Neue Datenquelle 11
    Server name: ANALYSISSERVER.MYDOMAIN.local

    Exception details:
    Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: Es kann keine Verbindung hergestellt werden. Stellen Sie sicher, dass der Server ausgeführt wird. ---> System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found
       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)

    We have one SharePoint Server with a separate database server and a third Analysis Services server.

    The web application uses Integrated Windows authentication with NTLM.

    The Performance Point Services Service Application and the Secure Store are set up, like here: The application pool's identity and the unattended service account have been set up as administrator in the Analysis Server. 

    In the dashboard designer (run as administrator) I choose "Unattended service account".

    How can I connect to the Analysis Server from the Dashboard Designer?

    • Moved by GuYuming Wednesday, August 18, 2010 3:56 AM PerformancePoint issue (From:SharePoint 2010 - Setup, Upgrade, Administration and Operation)
    Monday, August 16, 2010 4:19 PM


  • Bing Translation shows that the message in German means: "It cannot be contacted. Make sure that the server is running". So, can you connect to the Analysis Service on SharePoint Server where PerformancePoint service is running with tools such as SQL Server Management Studio?

    Wednesday, August 18, 2010 4:02 AM