dbTalk Databases Forums  

Cannot connect to Analysis Server through HTTP

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Cannot connect to Analysis Server through HTTP in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Deepak
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.