Unable to connect to SQL Server Analysis Services.
Article ID: KB0077658
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 7.5 and higher |
Description
While connecting to SQL server Analysis Services from Spotfire Analyst Client, an error might be seen immediately after clicking "Connect". This is shown below.
Spotfire Analyst Debug Logs will show the following error.
=====
ERROR Spotfire.Dxp.Forms.Data.Access.AsynchronousTaskManager [(null)] - Background task failed.
System.Data.DataException: The connection either timed out or was lost. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.Net.WebException: The remote name could not be resolved: 'myssas.test.lab'
=====
Spotfire Analyst Debug Logs will show the following error.
=====
ERROR Spotfire.Dxp.Forms.Data.Access.AsynchronousTaskManager [(null)] - Background task failed.
System.Data.DataException: The connection either timed out or was lost. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.Net.WebException: The remote name could not be resolved: 'myssas.test.lab'
=====
Issue/Introduction
Unable to connect to SQL Server Analysis Services.
Resolution
The above issue is seen if the server name of the SQL Server Analysis Services is not recognized by Spotfire. While connecting to SQL Server Analysis Services from Spotfire Analyst through connector, the "Server" value must be one of the following.
- Hostname of the SQL Server Analysis Services Server
- Fully Qualified Domain Name of the SQL Server Analysis Services Server
- IP address of the SQL Server Analysis Services Server
If the SQL Server Analysis Services Server has been configured for HTTP Access, which gives an HTTP URL to access the SSAS server, this URL cannot be used in Spotfire.
Feedback
Yes
No
Powered by
