PRB: ODBC DSN Issue when Browsing Cube Data from OLAP Manager on Remote Client (238034)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
This article was previously published under Q238034

SYMPTOMS

When browsing cube data on an OLAP server from the OLAP Manager on a remote client computer, the user gets the following message:
Cannot connect to the <DataSourceName> data source

CAUSE

This message can appear if the ODBC data source name (DSN) for the OLAP database is not defined on the remote client computer.

WORKAROUND

Define a DSN on the client computer with the same name as the one which has been defined for the cube that you want to browse in your OLAP server. For example, if you are accessing the sample FoodMart database on a remote OLAP server (the DSN is FoodMart) then an ODBC DSN name FoodMart should be defined on the client computer also. The DSN on the client computer should point to the same data source as the DSN defined on the server.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbprb KB238034
©2003 Microsoft Corporation. All rights reserved.