Excel MDX linked server fails connection test <p>My first post after 2 years of learning to write SQL and using SQL Server, most of my questions have been answered researching on this website, however I cannot find the answer to my question below:</p> <p>I am creating a new linked server, grabbing data from Excel using an MDX query in my SQL script. For example:</p> <pre><code>SELECT * into raw.example FROM openquery( Test1, 'MDX CODE/etc etc' </code></pre> <p>I clicked on my database > Server Objects > Linked Servers > New Linked Server > </p> <pre><code>Linker Server: TESTEXAMPLE Server Type: other data source Provider: Microsoft OLE DB Provider for Analysis Services 10.0 Product Name: Test1 Data Source: Name of server Provider String: Location: Catalog: OLAP </code></pre> <p>After I click "ok" to create this linked server this message comes up:</p> <blockquote> <p>The linked server has been created but failed a connection test. Do you want to keep the linked server?</p> <p>OLE DB provider 'MSOLAP' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode. (Microsoft SQL Server, Error: 7308)</p> </blockquote> <p>I am not sure why it isn't connecting. Is it a server issue where I have to ask for permission to access it? Or do I somehow need to revert away from the provider being configured to run in a single-threaded apartment mode?</p> <p>I am doing this on my local SQL Server Express Edition machine. Whereas before my script and <code>OPENQUERY/MDX</code> query worked on a remote desktop server etc.</p> <p>I have looked at other posts but those solutions do not solve my problem.</p>