Cannot connect to Analysis Server through HTTP -
04-03-2006
, 11:27 PM
When I try to access the Analysis server with HTTP://Analysis Server it
fails
my connection string looks like following:
<add key="OLAPConnectionString" value="Provider=MSOLAP.2;user
id=DOMAIN\User
Name=Password;Data Source=http://Analysis Server;Initial
Catalog=Foodmart
2000" />
The error I see is: the query could not be processed: The data provider
didn't supply any further error information.
I have installed Windows 2003 server with all latest patches and on the
same
server I have SQL Server 2000 (sp4), Analysis Server
(sp4), Project server 2003, and Sharepoint Server. I have updated
everything with latest Service packs and patches released by MS.
I have observed that I get the error when Application pool Identity is
set
to Network Service. But, when I change that to Local Service I don't
get
error that I specified earlier for OLAP.
I am not getting why so. And I also would like to know how I can
permit the
Network Service to access the Analysis Server with HTTP.
I will be grateful if anyone put some focus on my problem
Thanks in advance. |