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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×