Product: TIBCO Spotfire®
Unable to connect to SQL Server Analysis Services.
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'
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.