Data Mining Html Tree Viewer Authentication

I am going through the data mining web control viewer tutorial and its going great. I have been able to build and setup the viewer. The problem I am having is when I publish the site out to my web server, it gives me the following error:

Code Snippet

Error: Either the user, <domain>\<computerName>$, does not have access to the prospectDataMining database, or the database does not exist.

When I debug this on my local machine via Visual Studio 2005, it works GREAT! It is just when I publish the site to the web server.

I have a dedicated SSAS server along w/ a dedicated web server. To test, I published the site to the SSAS server to see if it was a connection issue. I received the same error w/ a different <domain>\<computerName>$.

I looked at trying to put in the optional connection info for the dataMining html tree viewer properties... but apparently dont know how to do that properly. I also checked the IIS directory security and enabled Integrated security.

What am i doing wrong? ANY help is much appreciated.

Thanks,

Cameron

Could you try the following:

- edit your web application's web.config file (add one to the project if not present)

- <configuration

<system.web>

<identity impersonate="true">

Setting up integrated security on the IIS virtual directory is necessary, but not enough -- .Net impersonates (or not) depending on the web.config file

Alternately, you could skip the web.config file changes and add Analysis Services permissions for thge localhost\ASPNET (only works if AS is on the same machine as IIS)