You cannot connect to SQL Server 2000 Analysis Services on a server that is running a 64-bit instance of SQL Server 2005 and a 64-bit instance of SQL Server 2005 Analysis Services

Article translations Article translations
Article ID: 947512 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario. You have a server that is running a 64-bit instance of Microsoft SQL Server 2005 and a 64-bit instance of Microsoft SQL Server 2005 Analysis Services. In this scenario, when you try to connect to SQL Server 2000 Analysis Services, you experience the following symptoms.

Symptom 1

In SQL Server Management Studio, when you try to use the Microsoft OLE DB Provider for Analysis Services 9.0 provider to create a linked server to SQL Server 2000 Analysis Services, you receive the following error message:
The linked server has been created but failed a connection test. Do you want to keep the linked server?
Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The OLE DB provider "MSOLAP" for linked server "LinkedServerName" reported an error. The provider did not give any information about the error.
Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "LinkedServerName"
This behavior does not occur if the server is running a 32-bit instance of SQL Server 2005.

Symptom 2

When you use the OPENROWSET function to connect to SQL Server 2000 Analysis Services, you receive one of the following error messages.
Error message 1
Msg 7302, Level 16, State 1, Line 2
Cannot create an instance of OLE DB provider "MSOLAP.2" for linked server "(null)".
Error message 2
OLE DB provider "MSOLAP" for linked server "(null)" returned message "The following system error occurred: No connection could be made because the target machine actively refused it."
Msg 7303, Level 16, State 1, Line 3
Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "(null)".

CAUSE

This behavior occurs because the 64-bit version of the SQL Server service cannot use the 64-bit version of the Microsoft OLE DB Provider for Analysis Services 9.0 provider to connect to SQL Server 2000 Analysis Services. Additionally, the 64-bit version of the Microsoft OLE DB Provider for Analysis Services 9.0 provider is not available on x64-based versions of Windows operating systems.

STATUS

This behavior is by design.

MORE INFORMATION

After you install a 64-bit instance of SQL Server 2005 Analysis Services, only the 64-bit version of the Microsoft OLE DB Provider for Analysis Services 9.0 provider is available. The 64-bit version of the SQL Server service can use this provider to connect to 64-bit instances of SQL Server 2005 Analysis Services and to 32-bit instances of SQL Server 2005 Analysis Services. However, the 64-bit version of the SQL Server service cannot use this provider to connect to SQL Server 2000 Analysis Services.

After you install a 32-bit instance of SQL Server 2005 Analysis Services, the 32-bit version of the Microsoft OLE DB Provider for Analysis Services 9.0 provider is available. If you are running the 32-bit version of the SQL Server service, the SQL Server service can use this provider to connect to SQL Server 2000 Analysis Services.

Properties

Article ID: 947512 - Last Review: January 30, 2008 - Revision: 1.1
APPLIES TO
  • Microsoft SQL Server 2005 Analysis Services
Keywords: 
kbsql2005bi kbsql2005as kbprb kbexpertiseadvanced kbtshoot KB947512

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com