Can Reporting services access Analysis Services over HTTP.
My SqlServer machine in behind a firewall and My reporting services needs to
access it.

if your remote AS server is enterprise, so you can through the msolap.asp
page.

Data source=http://asserver/folder (put the msolap.asp page in the /folder)

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> a écrit dans le message de
news:ekLws0XeEHA.3916 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Is that msolap.asp page already there (default)?
Or do I have to do all the stuff they say to do here:
http://msdn.microsoft.com/library/de...l_datapump.asp



"Jéjé" <willgart (AT) _A_hAotmail_A_ (DOT) com> wrote

this article appear to be usefull.
its the same objective using the same tools and components.
I think you are in the scenario 1 (where there is 3 type of connectivities
presented in the document) if IIS is installed on your analysis services
server. (or you can install it)

the msolap.asp page can be found under the sql server program file folder.
search for it and copy it in your wwroot folder.
Insure that only authenticated users can access this file (disable anonymous
acces; enable basic authentication; NT Authentication can cause some
problems with the firewall)
try a connection in Excel:
create a new document
create a connection to your cube (to use the pivottable)
type the address: http://analysisserver (and a login name/password;
optionnal)
and you'll see your cubes!
if you don't see your cube, the msolap.asp is not present or there is a
security problem.

good luck!

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> a écrit dans le message de
news:%2388oNUbeEHA.1764 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

Yes you can.

In the connection string just specify the data source as "http://servername.xx"

Make sure you pass in the UID and PWD.