1

Topic: Error. The supplier is not registered

e!
Wrote a SQL query with usage OPENROWSET which addresses to OLAP. Launched a SQL query to test basis - the request works. If to launch to working basis where is on other server does not work. "The supplier of an OLE DB" MSOLAP "writes is not registered.". If to come in Databases - Objects of the server - Linked servers - Suppliers there is MSOLAP. It turns out if in the list is MSOLAP should be registered.
How it is possible to bypass this problem? On what it is necessary to pay attention?

2

Re: Error. The supplier is not registered

Can be it is necessary what  to install an additional component?

3

Re: Error. The supplier is not registered

ferzmikk wrote:

As it is possible to bypass this problem? On what it is necessary to pay attention?

It is necessary to pay attention to councils of colleagues which try to convince you a second month that 2008 RTM is very bad idea. Very much.
It is necessary to pay attention that is necessary at once - if want to receive the answer - to write version SQL there, where test basis, and version SQL there, where the fighting. Whether both servers in one domain. From what name of security accounts services SQL and SSAS work.
Well also it is finite on the second server - where the fighting basis - to take and to register anew x64 the provider.
Approximately so, if 2012 .
Approximately so, if 2008 .
In general to spread more than the initial information and to improvise.

4

Re: Error. The supplier is not registered

Test and working basis MS SQL 2008 Standart Edition,
The server where OLAP is, an Enterprise Edition
Standart Edition can take the data from OLAP?

5

Re: Error. The supplier is not registered

ferzmikk wrote:

Test and working basis MS SQL 2008 Standart Edition,
The server where OLAP is, an Enterprise Edition
Standart Edition can take the data from OLAP?

Even Express Edition the data whence it can take necessary - where there is an OLE DB providers...

6

Re: Error. The supplier is not registered

Can be OLAP where that do not tear?

7

Re: Error. The supplier is not registered

ferzmikk wrote:

Can be OLAP where that do not tear?

Considering your phrase "If to launch to working basis where is on other server does not work" - that OLAP it is explicitly torn on "other" server where there is "a working" basis.
[spoiler]
You surprisingly obstinate. I  even envy your persistence a little.
What for to fight through openrowset when on "other" server it is possible to create linked server with necessary credentials, to check up operation there, and then to try to do select through openquery already on the necessary server, where "test" basis.
[/spoiler]