FIX: Can't connect to the server when you run a cube creation MDX query in SSAS 2012 or SSAS 2014

Applies to: SQL Server 2012 Analysis ServicesSQL Server 2014 Business IntelligenceSQL Server 2014 Business Intelligence

Symptoms


Assume that you connect to Microsoft SQL Server 2012 or 2014 Analysis Services that is running on a non-default port, and SQL Browser is set to off. When you execute a cube creation Multidimensional Expressions (MDX) query, you may receive the following error message:
Executing the query ...
Either a connection cannot be made to the "ServerName\Instance" server, or Analysis Services is not running on the computer specified.
Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'ServerName' server.
Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'ServerName' server.
Execution complete

Cause


The issue occurs because the incorrect code path is taken. A connection always tries to use the instance name format, which relies on SQL Browser.

Resolution


After you apply the hotfix, set the value of LocalCubeServerPortInConnectionString to 1 to enable this feature in the SSAS configuration file.

Service pack information for SQL Server 2014

To resolve this issue, obtain Service Pack 1 for SQL Server 2014.

For more information about SQL Server 2014 Service Pack 1 (SP1), see bugs that are fixed in SQL Server 2014 Service Pack 1 .


Service pack information for SQL Server 2012

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2012. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2755533 How to obtain the latest service pack for SQL Server 2012

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.