MS SQL Server OLAP - IIS anonymous access problem

Author

IIS anonymous access problem

2005-12-19, 9:23 am

Hello,
I'm having problems setting up anonymous access to Analysis Services
(SQL Server 2000 Enterprise on MSW AS 200) via IIS.

I've set up a virtual directory on IIS, with Directory Security
Authentication Method set to Anonymous only, the anonymous user account
set to IUSR_computername account.
The account is included w/in the Analysis Services Database and Cube
roles.
Both the IIS and Analysis Services run on the same machine.

The connection string w/in the html page containing the Pivot Table
object reads as follows:
"Provider=msolap.2;Persist Security Info=True;Data
Source=<computername>;Initial Catalog=<catalog name>;SSPI=anonymous";

I try to connect to the web page from a client in a different domain
than the AS machine, logged in under account named, say,
'ClientAccount'.

The Pivot Table remains empty, reporting 'Unable to connect to data'.

The System Security Log on the AS server reports Login failure for
'ClientAccount' - well, I would assume the ClientAccount should have
been translated to 'IUSR_computername' by IIS though, right?

If I include the 'Everyone' group w/in the Cube roles, everything works
just fine.
Any suggestions on what to double check to see why IIS does not
correctly translate client connections to the anonymous account?

TIA.

Darren Gosbell

2005-12-20, 7:23 am

Your problem is not with IIS, it is to do with the fact that the OWC
PivotTable component is an ActiveX component which runs on the client
and makes its own connection back to the AS server, independent from the
HTML page which is hosting the control.

If you want to connect as the anonymous user you will need to setup some
form of HTTP connectivity.

If you have the Enterprise Edition you can setup HTTP authentication. If
you have the Standard Edition I think you will need to look into setting
up XML/A.

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

In article <1135004625.052419.295140@z14g2000cwz.googlegroups.com>,
jiri.dejm@ct.cz says...
> Hello,
> I'm having problems setting up anonymous access to Analysis Services
> (SQL Server 2000 Enterprise on MSW AS 200) via IIS.
>
> I've set up a virtual directory on IIS, with Directory Security
> Authentication Method set to Anonymous only, the anonymous user account
> set to IUSR_computername account.
> The account is included w/in the Analysis Services Database and Cube
> roles.
> Both the IIS and Analysis Services run on the same machine.
>
> The connection string w/in the html page containing the Pivot Table
> object reads as follows:
> "Provider=msolap.2;Persist Security Info=True;Data
> Source=<computername>;Initial Catalog=<catalog name>;SSPI=anonymous";
>
> I try to connect to the web page from a client in a different domain
> than the AS machine, logged in under account named, say,
> 'ClientAccount'.
>
> The Pivot Table remains empty, reporting 'Unable to connect to data'.
>
> The System Security Log on the AS server reports Login failure for
> 'ClientAccount' - well, I would assume the ClientAccount should have
> been translated to 'IUSR_computername' by IIS though, right?
>
> If I include the 'Everyone' group w/in the Cube roles, everything works
> just fine.
> Any suggestions on what to double check to see why IIS does not
> correctly translate client connections to the anonymous account?
>
> TIA.
>
>

2005-12-20, 9:24 am

Thank you.

I changed the Data Source property of the OWC Pivot table to the
http://directory where msolap.asp was set up.

Now, I don't get the error messages any more, but neither does the
PivotTable show up in the browser. IE just hangs with the 'Not
responding' state, without any response whatsoever. What should I check
next? Thanks a lot.

Darren Gosbell

2005-12-21, 3:24 am

Not sure, there are a couple of things that you could try.

1) try connecting from Excel using http, this might give you some sort
of error message to tell you what is going on.

2) you could try specifying the username and password in the connection
string.

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

In article <1135088127.587603.173740@g44g2000cwa.googlegroups.com>,
jiri.dejm@ct.cz says...
> Thank you.
>
> I changed the Data Source property of the OWC Pivot table to the
> http://directory where msolap.asp was set up.
>
> Now, I don't get the error messages any more, but neither does the
> PivotTable show up in the browser. IE just hangs with the 'Not
> responding' state, without any response whatsoever. What should I check
> next? Thanks a lot.
>
>

Sponsored Links