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 |