Hello,

Our project is to do HTTP reporting on an AS cube, using PTS and dynamical
tables.
Our environment is: SQL server 2K on a windows 2k advanced server. We have
no domain, IIS 5. Clients are using win2k pro or Winxp pro + excel 2003. All
clients have latest PTS / MDAC / OWC.
We tried HTML and ASP pages. The problem is that when the clients are trying
to hit AS, we get an error message either stating that we dont have the
rights to access the cube, or that the cube we are trying to access is non
existant (which i know is false).

Im pretty sure the problem is due to authentification. IIS send the
IUSR_<machine name> user to AS. This user is refused. I created a "cube"
group in local users on the server, giving that group all kind of rights and
putting inside the NT AUTHORITY\ANONYMOUS LOGON + IUSR + everybody. Created a
server role in AS with those users. Nothing work.

Any kind of help would be appreciated

Thanks

is IIS and AS on the same machine? Are you using direct conxn or the small asp page supplied with AS? It could be that you can't pass the crednetials over more than 1 hop.

--
Message posted via http://www.sqlmonster.com

Check that the file "msolap.asp" is present in your virtual directory as set
up in your IIS. Without this file you can't use the HTTP protocol to access
AS's cubes.

Nestor




"Gilles B" <GillesB (AT) discussions (DOT) microsoft.com> wrote

We are using direct connexion and IIS and AS are on the same server.
The msolap.asp file is present in c:\inetpub\wwwroot;
c:\inetpub\wwwroot\web_site; \programm files\microsoft as\bin;

Next step is to try and change SQL release are we are using the standard
edition atm. Althought i have seen it work with this release its worth trying
the enterprise edition.

Thanks for the answers anyway, feel free to post any further ideas you could
come with

"Nestor" wrote:

I don't remember SQL2k Standard edition allows HTTP access. Only the
enterprise edition of SQL2k (and developer edition) allows access of AS
cubes through HTTP. I'm quite confident that if you've switched to
Enterprise edition you'll not encounter these problems.

Let me know again if you got it working in Standard edition.


"Gilles B" <GillesB (AT) discussions (DOT) microsoft.com> wrote

I know for a fact this can work with the standard edition as the guys doing
the sql part for us made it work at their office.
However, they have a more conventional network as they use microsoft's
domain approbations.

At the moment, im still waiting on my enterprise CD, will keep you informed
if it fixes it.

Anyway, thanks for answering

"Nestor" wrote:

I was pretty sure that only enterprise edition would allow this.

-aaron


"Gilles B" <GillesB (AT) discussions (DOT) microsoft.com> wrote