dbTalk Databases Forums  

Problem with ADOMD 8.0

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


Discuss Problem with ADOMD 8.0 in the microsoft.public.sqlserver.olap forum.



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

Default Problem with ADOMD 8.0 - 01-09-2006 , 10:47 AM






I used a ADOMD 8.0 driver for retrieve information's olap cube. When I test
my app on pc test the result is ok.
But when I deply my app on server prod. I receive this message "A connection
cannot be made. Ensure that the server is running. " from page aspx.

I don't understand because the olap's roles are ok, and with another
application for consulting olap cube can view correctly olap cube.

Can the problem be in the code or it is in the authorization of windows 2003
of the server of production?

PS: pc test is Windows XP Pro SP2 with IIS 5.0 and ps prod. is Windows 2003
STD with IIS 6.0




Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Problem with ADOMD 8.0 - 01-10-2006 , 04:52 AM






There could be any one of a number of issue here.

What sort of connection string are you using?

If you are trying to use a standard TCP connection - It could be IIS6.
By default IIS6 will run ASP.NET applications using the NETWORK SERVICE
account, on the other hand IIS5 will use the ASPNET user. So you may
need to double check the roles.

If you want to pass the users credentials from a client, to the web
browser, to the Analysis Server you will need to either set up Kerberos
or HTTP authentication.

It could also be the version of the Olap Provider on the server. If the
application and Analysis Server are separate machines you should make
sure that you have run the PTSLite.exe that came with the current
service pack that you have on the AS server.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <E19B4894-489B-44D7-8EA7-D30638B9794D (AT) microsoft (DOT) com>, "=?Utf-
8?B?RGFyaW8gQ29uY2lsaW8=?=" <Dario Concilio (AT) discussions (DOT) microsoft.com>
says...
Quote:
I used a ADOMD 8.0 driver for retrieve information's olap cube. When I test
my app on pc test the result is ok.
But when I deply my app on server prod. I receive this message "A connection
cannot be made. Ensure that the server is running. " from page aspx.

I don't understand because the olap's roles are ok, and with another
application for consulting olap cube can view correctly olap cube.

Can the problem be in the code or it is in the authorization of windows 2003
of the server of production?

PS: pc test is Windows XP Pro SP2 with IIS 5.0 and ps prod. is Windows 2003
STD with IIS 6.0






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.