Error Messages/40855
Example error messages
In MdxQuery(): Item cannot be found in the collection corresponding to the requested name or ordinal.'"In MdxQuery(): SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]."
Causes
This error corresponds to the error code 0x800a0cc1. Searching the internet for this code may provide some clues.
Once you've solved the problem, please edit this page and explain the cause for the benefit of users who may encounter the same later.
Specific errors
Error locating server
"In MdxQuery(): SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]."
In the case we encountered this, the connection string points to a different computer:
"Provider=SQLNCLI11.1;Data Source=COMPUTER1\INSTANCE1;Persist Security Info=True;User ID=sa;Initial Catalog=MyDB"
We believe this error means that either the computer can't be found by its name ("COMPUTER1") or the instance name ("INSTANCE1") can't be found. If you are not sure which it is, see this blog article:
If it is an incorrect server name, then it might be that the DNS can't find the computer, or there's a general network issue. if it is the instance that isn't found, then it might be something like a firewall blocking access.
Enable comment auto-refresher