Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


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


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.


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


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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!