Hi,

I'm a newbie when it comes to working with OLAP and Analysis Services,
and I'm having a problem getting data to my browser. Here is my basic
setup:

Local client on an internal network connecting to a Win2003 server in
a DMZ. Analysis Services, IIS, and SQL Server2k are all installed on
the server. I have developed an aspnet site that connects to Analysis
Services and using OWC components displays dynamic graphs to the user
through their browser. Everything works fine when I am term-served
onto the server and access the site (which is using basic
authentication). However, when I attempt to access the site from my
PC using credentials of a local admin on the server, I get access to
the site but I get the error:

"Failed to get data - The operation requested failed due to security
problems - the user could not be authenticated"

I have read through other postings and tried various solutions
suggested, but none of them seem to work for me. In my Analysis
Services, I have only one database role defined and Everyone is
assigned to it, and there are no cube or dimension level restrictions.
I have added the aspnet account to the Olap Administrators group on
the server and that has not fixed the problem either.

Has anyone seen this problem before? Is this an issue with being
unable to connect to the Analysis Server, or is it something in the
database roles themselves.

Thanks in advance...

in IE on your client machine, you need to add the server as trusted site:
IE> internet option> security> trusted site> add
and then you add the url.

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

Hi Allison....thanks for the response. I had already added the site as
a trusted site in my IE and it still wasn't working. I have since
managed to get past this problem. I had not properly configured AS for
http requests....I had not added my msolap.asp file to the proper
directories and my connection string was wrong. Now, of course, I have
more problems....I need to have basic authentication enabled on the web
site, and if I put basic authentication on the msolap.asp file as
directed, the OWC components no longer render and I get errors. If I
leave anonymous access on the msolap file but basic authentication on
the virtual directory, then things seem to work properly, but I get
prompted to login everytime I refresh the page or click a hyperlink,
which shouldn't be happening as I am already logged in on the site.....

Any thoughts?

Try adding prompt=1 to the OWC connectstring. It will prompt you for uid/pwd
to be used for basic authentication. Or, I suppose you could also hardcode
the uid/pwd on the connectstring if you want, but prompt=1 is easier.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

<wardy1975 (AT) yahoo (DOT) com> wrote

Hi Dave...thanks for the suggestion. I have tried both with prompt=1
and with the user/pass hardcoded in the connection string, but I still
get prompted multiple times to log in.

Basically, the first time I access the web site, I get prompted as I
should and I log in. If I then click Refresh or click a hyperlink on
the page, I get prompted to log in again. Once I have done this, I do
not get prompted to login again unless I click Refresh on the main
page, for which I don't get prompted to login, but if I click a
hyperlink on the page after the Refresh action, I get the login prompt.


Any thoughts?

As a further follow up, it seems that if I remove the site from my
Trusted Sites list, I do not get the strange login behaviour except for
the refreshing of the main page that contains 2 OWC controls. Clicking
hyperlinks in this scenario never results in a re-login prompt.
Strange why having the site as Trusted (to stop the warning from the
browser about content) would cause this behaviour.