416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

SQL Server Analysis Services Connectivity Issues

Hide navigation
Modified on Tue, 02 Apr 2013 10:36 AM

Below are some notes to help you with troubleshooting connectivity issues to SQL Server Analysis Services (SSAS) data sources.

SSAS connectivity issues

Unable to connect to a remote SSAS 2005 data source

You may receive the following error message when attempting to create a data connector to a SSAS 2005 data source on a remote server:

Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running on your SSAS server.
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.

To resolve this issue, ensure that your SSAS server is set up to allow remote connections:

  1. Use the SQL Server Surface Area Configuration tool from your SSAS server to verify that remote connections are enabled.
  2. Make sure the SQL Browser Service is running.
  3. If your SSAS server is using a firewall (or anti-virus software), ensure that TCP ports 2382 and 2383 are both open.
  4. Check your SSAS server properties and make sure that, under your General settings, the Network \ ListenOnlyOnLocalConnections property is set to False.

If the above items don’t resolve your connection issue, you may want to review this MS TechNet article that outlines, in more detail, some other issues that can cause connectivity issues with SSAS: Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios

Unable to connect to a SSAS server that is running on a computer that is on a different domain

If you are trying to connect to a SSAS server that is running on a computer that is on a different domain you may see the following error message: "Logon failure: unknown user name or bad password".

Please follow the steps below in order to connect:

  1. When creating a Dundas Dashboard data connector, click the Connect As check box and enter a Windows user name and password.
  2. Leave the domain name empty.
  3. On the server where Analysis Services is running add one local user with the same credentials as the Windows account that you used in the Dundas Dashboard data connector.
  4. Add this user to the SSAS server security:
    • Connect to your SSAS server from SQL Server Management Studio.
    • Right click on your SSAS server and choose Properties.
    • Click the Security tab and add the account that you just created.
  5. Now try to connect to the SSAS server from Dundas Dashboard.

Related topics

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.