Showing posts with label web. Show all posts
Showing posts with label web. Show all posts

Wednesday, March 7, 2012

Another database design issue help!

Hello all,
I am developing a web application and im in the middle of database design and facing a design issue. Here it is: A table for products a table for SizeChart (Small, Medium, Large) ColorChart (White, Ash, Yellow, Pink).
Each product is available in combination of different colors and size. Then product has images which are stored based on the selection from ColorChart table. I have created a table where many to many relation between product to color and size are related with primary key identity field for junction table too. I also have created a table tblProdImages with ProductID, ColorID, ImagePath fields
Here is the structure
Product ColorChart SizeChart
--- ---- ----
ProductID ColorID SizeID
Name ColorIcon Sybol

ProductColorSizeChart (junstcion table) ProductImages
------------ ------
ProductColorSizeID (Indentity) ProductImageID (Identity)
ProductID - FK ProductID - FK
ColorID - FK ColorID - FK
SizeID - FK ImagePathThumbnail
InStock ImagePathLarge
Offline

I have write DAL for product and managing junction table relation as collection in my product b/e object.
Here is my question
1- How effective this whole db schema is and how manageable is the relations, Suggest if any better solutions is.
2- Im facing updating problem in ProductDAL for updating collection items in database.
3- How can i manage and implement lazy loading in this scenario in my own written Data Access Layer.

Please clarify 'DAL' and 'b/e'|||1) The schema looks pretty good. The relationships look fairly straight forward and easy to maintain.
2 ) It would help if I had a better idea of what your Object Model & DAL look like.
3) It doesnt look like you have a situation where objects have amassive amount of data associated with them. Im not sureLazyLoading would be worth the trouble. Caching the objects andreturning references might be more useful for you.
|||Thanks Jeffrey for a prompt reply. First of all as far as b/e (business entity objects) are concerned they are blue print parent tables. As for relation btw product, color, size i have created a collection where each item is a structure having two fields for b/e of ColorInfo and SizeInfo (mapper of Color and Size tables). There is a possibility that a product may need to be added where this relation may not be applied as that product has no dependency of color and size so the collection will be empty and in DAL (Data Access Layer) class of product i have this check to determin the count of collection. If empty then Save method for relational entity objects will not be called.
I have implemented DAL code for saving relational object (Product,Color,Size) in product. Is it a right place?|||

asp.dude wrote:

Thanks Jeffrey for a prompt reply. First of allas far as b/e (business entity objects) are concerned theyare blue print parent tables. As for relation btw product, color, sizei have created a collection where each item is a structure havingtwo fields for b/e of ColorInfo and SizeInfo (mapper of Color and Sizetables). There is a possibility that a product may need to be addedwhere this relation may not be applied as that product has nodependency of color and size so the collection will be empty and in DAL(Data Access Layer) class of product i have this check to determin thecount of collection. If empty then Save method for relational entityobjects will not be called.
I have implemented DAL code for saving relational object (Product,Color,Size) in product. Is it a right place?


Thatsounds correct to me. I really couldnt tell you much more without seeing code.

Anonymous connection to a remote server

I have a SQL server running on a Win2k Domain Controller set for Windows Aut
hentication only.
I have a Windows 2003 Web Edition server that is a member of the domain.
When permissions are correct I can open and update databases on the server f
rom the Web Edition server.
I want to allow anyone that hits a web site on the 2003 server to be able to
update a specific database on the SQL server. The
users on that site are running under the local IIS anonymous user id.
I tried the obvious and simple connection
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Ini
tial Catalog=WebRedirectLog;Data Source=ZEUS;
Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation
ID=ROY;Use Encryption for Data=False;
Tag with column collation when possible=False");
(which I expected to fail) and it did telling me
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Se
rver connection.
(I did NOT supply a userid in the call to ADODB.Connection.Open
What is the correct way to do one of the following.
1) - Allow all users (authenticated or not) to update a database?
2) - Set up the SQL server so that it can treat the 2003 local account (not
a domain account) as authenticated.
I do NOT want to allowed mixed mode authentication on this server.
Please bear in mind, I am still a novice at administering SQL, so please mak
e your response a little detailed.
Thanks
---
Roy Chastain
KMSystems, Inc.Hi Roy,
Welcome to MSDN newsgroup.
Regarding on the problem you mentioned, I think the it'll be a bit
difficult to meet all your requirement. Here are some of my understandings:
First, ASP will always impersonate the anonymous account( IIS's default
IUSR_machine account) if we enable anonymous access in our IIS virtual dir.
Then, when our asp page try accessing any protected resource, the
IUSR_machine account will be the authenticated and executing account of our
asp page's thread. Then, return back to the quesitons you mentioned:
==============
What is the correct way to do one of the following.
1) - Allow all users (authenticated or not) to update a database?
2) - Set up the SQL server so that it can treat the 2003 local account (not
a domain account) as authenticated
==============
1) I think the most standard means for allow all users to access db is to
use SQLServer Autehntcaiton(provide the username account in
connectionstring. This will require the SQLServer db to allow SQL
authentication. In fact, this is limited by the ASP , in asp.net we can
impersonate a certain fixed account so as to use t hat account to access
the database through integrated windows authentication.
2) If the webserver and SqlServer's database server is the same box, we
can simply grant the IIS's IUSR_MACHINE account the permisson to access
sqlserver db. However, as you said the DB server is a remote server to the
webserver, the IUSR_machine(local account ) on webserver is not valid on DB
server. For such scenario, there are two options:
a. use a Domain Account as your IIS virtual dir's anonymous account.
(Seems you didn't want to use DomainAcount )
b. create a duplicate local account on the SQLServer 's machine which has
the same username and password with the IIS virtual dir's anonymous account
(on the webserver box). However, the IIS's default anonymous account(
IUSR_MACHINE) 'S password is controled by machine rather than ourself. So
we need to either explicitly set IUSR_MACHINE's password or create a
custom local account and replace the IUSR_machine as the virtual dir's
anonymous account.
Anyway, since there hasn't any means which will satisfy all the
requirement, we may need to make our decision according to the actual
situation. Please have a look of all the above things and feel free to let
us know if you have any ideas.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Here is what I did and it is working and I think secure for what I want.
I created a new domain account and gave it insert and select access to the d
atabase.
I set anonymous access for the web site to that account.
I created a Application Pool on the web server and have it running under tha
t account.
I set the web site to use the newly created Application Pool.
From my point of view that gives all anonymous users of this one web site an
onymous access to the SQL database for the purposes of
inserting and selecting. I would have been easier is SQL supported some sor
t of anonymous access setting that said don't validate
this user, just let them do this, but...
Please let me know if you see any flaws in my reasoning.
Thanks
On Thu, 14 Apr 2005 05:18:35 GMT, v-schang@.online.microsoft.com (Steven Chen
g[MSFT]) wrote:

>Hi Roy,
>Welcome to MSDN newsgroup.
>Regarding on the problem you mentioned, I think the it'll be a bit
>difficult to meet all your requirement. Here are some of my understandings:
>First, ASP will always impersonate the anonymous account( IIS's default
>IUSR_machine account) if we enable anonymous access in our IIS virtual dir.
>Then, when our asp page try accessing any protected resource, the
>IUSR_machine account will be the authenticated and executing account of our
>asp page's thread. Then, return back to the quesitons you mentioned:
>==============
>What is the correct way to do one of the following.
>1) - Allow all users (authenticated or not) to update a database?
>2) - Set up the SQL server so that it can treat the 2003 local account (not
>a domain account) as authenticated
>==============
>1) I think the most standard means for allow all users to access db is to
>use SQLServer Autehntcaiton(provide the username account in
>connectionstring. This will require the SQLServer db to allow SQL
>authentication. In fact, this is limited by the ASP , in asp.net we can
>impersonate a certain fixed account so as to use t hat account to access
>the database through integrated windows authentication.
>2) If the webserver and SqlServer's database server is the same box, we
>can simply grant the IIS's IUSR_MACHINE account the permisson to access
>sqlserver db. However, as you said the DB server is a remote server to the
>webserver, the IUSR_machine(local account ) on webserver is not valid on DB
>server. For such scenario, there are two options:
>a. use a Domain Account as your IIS virtual dir's anonymous account.
>(Seems you didn't want to use DomainAcount )
>b. create a duplicate local account on the SQLServer 's machine which has
>the same username and password with the IIS virtual dir's anonymous account
>(on the webserver box). However, the IIS's default anonymous account(
>IUSR_MACHINE) 'S password is controled by machine rather than ourself. So
>we need to either explicitly set IUSR_MACHINE's password or create a
>custom local account and replace the IUSR_machine as the virtual dir's
>anonymous account.
>Anyway, since there hasn't any means which will satisfy all the
>requirement, we may need to make our decision according to the actual
>situation. Please have a look of all the above things and feel free to let
>us know if you have any ideas.
>Thanks,
>Steven Cheng
>Microsoft Online Support
>Get Secure! www.microsoft.com/security
>(This posting is provided "AS IS", with no warranties, and confers no
>rights.)
>
>
---
Roy Chastain
KMSystems, Inc.|||Glad to hear from you Roy,
I think it's OK since ASP will impersonate the authenticated user by
default( if allow anonymous then impersonate the anonymous user). And
using Integrated windows authentication at back end db is also what we
recommend.
BTW, is there any future action plan that you'll migrate your web
application from classic ASP to ASP.NET. The asp.net web app framework will
have more strong support for stable and high performance web application.
Also, as for security, the asp.net can let the asp.net running under the
process idenity (the application pool identity in IIS6) together with allow
anonymous in IIS. Thus, we can still keep the IIS's anonymous account as a
very restricted account.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Anonymous connection to a remote server

I have a SQL server running on a Win2k Domain Controller set for Windows Authentication only.
I have a Windows 2003 Web Edition server that is a member of the domain.
When permissions are correct I can open and update databases on the server from the Web Edition server.
I want to allow anyone that hits a web site on the 2003 server to be able to update a specific database on the SQL server. The
users on that site are running under the local IIS anonymous user id.
I tried the obvious and simple connection
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=WebRedirectLog;Data Source=ZEUS;
Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ROY;Use Encryption for Data=False;
Tag with column collation when possible=False");
(which I expected to fail) and it did telling me
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
(I did NOT supply a userid in the call to ADODB.Connection.Open
What is the correct way to do one of the following.
1) - Allow all users (authenticated or not) to update a database?
2) - Set up the SQL server so that it can treat the 2003 local account (not a domain account) as authenticated.
I do NOT want to allowed mixed mode authentication on this server.
Please bear in mind, I am still a novice at administering SQL, so please make your response a little detailed.
Thanks
Roy Chastain
KMSystems, Inc.
Hi Roy,
Welcome to MSDN newsgroup.
Regarding on the problem you mentioned, I think the it'll be a bit
difficult to meet all your requirement. Here are some of my understandings:
First, ASP will always impersonate the anonymous account( IIS's default
IUSR_machine account) if we enable anonymous access in our IIS virtual dir.
Then, when our asp page try accessing any protected resource, the
IUSR_machine account will be the authenticated and executing account of our
asp page's thread. Then, return back to the quesitons you mentioned:
==============
What is the correct way to do one of the following.
1) - Allow all users (authenticated or not) to update a database?
2) - Set up the SQL server so that it can treat the 2003 local account (not
a domain account) as authenticated
==============
1) I think the most standard means for allow all users to access db is to
use SQLServer Autehntcaiton(provide the username account in
connectionstring. This will require the SQLServer db to allow SQL
authentication. In fact, this is limited by the ASP , in asp.net we can
impersonate a certain fixed account so as to use t hat account to access
the database through integrated windows authentication.
2) If the webserver and SqlServer's database server is the same box, we
can simply grant the IIS's IUSR_MACHINE account the permisson to access
sqlserver db. However, as you said the DB server is a remote server to the
webserver, the IUSR_machine(local account ) on webserver is not valid on DB
server. For such scenario, there are two options:
a. use a Domain Account as your IIS virtual dir's anonymous account.
(Seems you didn't want to use DomainAcount )
b. create a duplicate local account on the SQLServer 's machine which has
the same username and password with the IIS virtual dir's anonymous account
(on the webserver box). However, the IIS's default anonymous account(
IUSR_MACHINE) 'S password is controled by machine rather than ourself. So
we need to either explicitly set IUSR_MACHINE's password or create a
custom local account and replace the IUSR_machine as the virtual dir's
anonymous account.
Anyway, since there hasn't any means which will satisfy all the
requirement, we may need to make our decision according to the actual
situation. Please have a look of all the above things and feel free to let
us know if you have any ideas.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Here is what I did and it is working and I think secure for what I want.
I created a new domain account and gave it insert and select access to the database.
I set anonymous access for the web site to that account.
I created a Application Pool on the web server and have it running under that account.
I set the web site to use the newly created Application Pool.
From my point of view that gives all anonymous users of this one web site anonymous access to the SQL database for the purposes of
inserting and selecting. I would have been easier is SQL supported some sort of anonymous access setting that said don't validate
this user, just let them do this, but...
Please let me know if you see any flaws in my reasoning.
Thanks
On Thu, 14 Apr 2005 05:18:35 GMT, v-schang@.online.microsoft.com (Steven Cheng[MSFT]) wrote:

>Hi Roy,
>Welcome to MSDN newsgroup.
>Regarding on the problem you mentioned, I think the it'll be a bit
>difficult to meet all your requirement. Here are some of my understandings:
>First, ASP will always impersonate the anonymous account( IIS's default
>IUSR_machine account) if we enable anonymous access in our IIS virtual dir.
>Then, when our asp page try accessing any protected resource, the
>IUSR_machine account will be the authenticated and executing account of our
>asp page's thread. Then, return back to the quesitons you mentioned:
>==============
>What is the correct way to do one of the following.
>1) - Allow all users (authenticated or not) to update a database?
>2) - Set up the SQL server so that it can treat the 2003 local account (not
>a domain account) as authenticated
>==============
>1) I think the most standard means for allow all users to access db is to
>use SQLServer Autehntcaiton(provide the username account in
>connectionstring. This will require the SQLServer db to allow SQL
>authentication. In fact, this is limited by the ASP , in asp.net we can
>impersonate a certain fixed account so as to use t hat account to access
>the database through integrated windows authentication.
>2) If the webserver and SqlServer's database server is the same box, we
>can simply grant the IIS's IUSR_MACHINE account the permisson to access
>sqlserver db. However, as you said the DB server is a remote server to the
>webserver, the IUSR_machine(local account ) on webserver is not valid on DB
>server. For such scenario, there are two options:
>a. use a Domain Account as your IIS virtual dir's anonymous account.
>(Seems you didn't want to use DomainAcount )
>b. create a duplicate local account on the SQLServer 's machine which has
>the same username and password with the IIS virtual dir's anonymous account
>(on the webserver box). However, the IIS's default anonymous account(
>IUSR_MACHINE) 'S password is controled by machine rather than ourself. So
>we need to either explicitly set IUSR_MACHINE's password or create a
>custom local account and replace the IUSR_machine as the virtual dir's
>anonymous account.
>Anyway, since there hasn't any means which will satisfy all the
>requirement, we may need to make our decision according to the actual
>situation. Please have a look of all the above things and feel free to let
>us know if you have any ideas.
>Thanks,
>Steven Cheng
>Microsoft Online Support
>Get Secure! www.microsoft.com/security
>(This posting is provided "AS IS", with no warranties, and confers no
>rights.)
>
>
Roy Chastain
KMSystems, Inc.
|||Glad to hear from you Roy,
I think it's OK since ASP will impersonate the authenticated user by
default( if allow anonymous then impersonate the anonymous user). And
using Integrated windows authentication at back end db is also what we
recommend.
BTW, is there any future action plan that you'll migrate your web
application from classic ASP to ASP.NET. The asp.net web app framework will
have more strong support for stable and high performance web application.
Also, as for security, the asp.net can let the asp.net running under the
process idenity (the application pool identity in IIS6) together with allow
anonymous in IIS. Thus, we can still keep the IIS's anonymous account as a
very restricted account.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Saturday, February 25, 2012

Anonymous Access from Pivot Table to OLAP 2005

My asp-net web application connect to Analysis Services 2005 through Pivot Table client.

To use anonymous access with AS2000 i used to add this property to the connection string of the pivot: "SSPI=anonymous".

Which property give me the same thing with AS2005?

Thanks!

Hi,

The SSPI connection property is still there, so it should work the same. Are you getting an error?

David Botzenhart

|||

Hey David - good to hear from you !

Yes, you could still use SSPI=anonymous, but I really recommend in AS2005 to use standard OLEDB property for this purpose, i.e.

Protection Level=none

It has slightly better (more standard) behavior.

Mosha (http://www.mosha.com/msolap )

|||

Thanks, it's working.

But, if i set "Impersonation Level" property to Anonymous? Is this the same of SSPI=anonymous?

Friday, February 24, 2012

Ann:www.SQL-Scripts.Com

Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have scripts that you use why not
lodge them on our site. If you lodge your script you could win a prize. In
addition to scripts there are many documents, news feeds and articles.
We have a monthly contest for the first people to lodge 20 scripts in one
month.
Please help to make this site great.
Webmaster at www.SQL-Scripts.com
You are spamming this group. Please cease & desist.
Lots of people manage to get commercial messages expressed by the simple
expedient of placing their URL or service statement in their signature line.
Note that spam messages are not their mode. They get their messages out by
responding intelligently to huge volumes of posts. They really help people
and they're here more to give than to get
HTH
-Larry-
"www.sql-scripts.com" <webmasterNOSPAM@.SQL-SPAM-Scripts.Com> wrote in
message news:udzZVZlJEHA.624@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Announcing the release of a new web site : www.SQL-Scripts.com
> At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
> different database system. Using our search system you can find scripts
> that you need quickly and simply. If you have scripts that you use why
not
> lodge them on our site. If you lodge your script you could win a prize.
In
> addition to scripts there are many documents, news feeds and articles.
> We have a monthly contest for the first people to lodge 20 scripts in one
> month.
> Please help to make this site great.
> Webmaster at www.SQL-Scripts.com
>

Ann:www.SQL-Scripts.Com

Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have scripts that you use why not
lodge them on our site. If you lodge your script you could win a prize. In
addition to scripts there are many documents, news feeds and articles.
We have a monthly contest for the first people to lodge 20 scripts in one
month.
Please help to make this site great.
Webmaster at www.SQL-Scripts.com
You are spamming this group. Please cease & desist.
Lots of people manage to get commercial messages expressed by the simple
expedient of placing their URL or service statement in their signature line.
Note that spam messages are not their mode. They get their messages out by
responding intelligently to huge volumes of posts. They really help people
and they're here more to give than to get
HTH
-Larry-
"www.sql-scripts.com" <webmasterNOSPAM@.SQL-SPAM-Scripts.Com> wrote in
message news:udzZVZlJEHA.624@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Announcing the release of a new web site : www.SQL-Scripts.com
> At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
> different database system. Using our search system you can find scripts
> that you need quickly and simply. If you have scripts that you use why
not
> lodge them on our site. If you lodge your script you could win a prize.
In
> addition to scripts there are many documents, news feeds and articles.
> We have a monthly contest for the first people to lodge 20 scripts in one
> month.
> Please help to make this site great.
> Webmaster at www.SQL-Scripts.com
>

Thursday, February 16, 2012

Analysis Services web application authentication problem

In the following sceanrio
Web application uses Analysis Services to present data.
Web App (IIS) is installed on a different server to the SQL Server instance.
Web app uses Windows Integrated authentication.
It appears that the authentication is not correctly passed to AS and that
the app then fails.
This does not seem to be the case where AS and IIS are installed on the same
machine.
Does this sound familiar and if so are you aware of any fixes/workaroundsBTW: If the web app uses basic authentication then everything works......
"Andrew Wiles" <ajw@.nospam.please> wrote in message
news:edNjY9rhEHA.1964@.tk2msftngp13.phx.gbl...
> In the following sceanrio
>
> Web application uses Analysis Services to present data.
> Web App (IIS) is installed on a different server to the SQL Server
instance.
> Web app uses Windows Integrated authentication.
>
> It appears that the authentication is not correctly passed to AS and that
> the app then fails.
>
> This does not seem to be the case where AS and IIS are installed on the
same
> machine.
>
> Does this sound familiar and if so are you aware of any fixes/workarounds
>

Analysis Services web application authentication problem

In the following sceanrio
Web application uses Analysis Services to present data.
Web App (IIS) is installed on a different server to the SQL Server instance.
Web app uses Windows Integrated authentication.
It appears that the authentication is not correctly passed to AS and that
the app then fails.
This does not seem to be the case where AS and IIS are installed on the same
machine.
Does this sound familiar and if so are you aware of any fixes/workarounds
BTW: If the web app uses basic authentication then everything works......
"Andrew Wiles" <ajw@.nospam.please> wrote in message
news:edNjY9rhEHA.1964@.tk2msftngp13.phx.gbl...
> In the following sceanrio
>
> Web application uses Analysis Services to present data.
> Web App (IIS) is installed on a different server to the SQL Server
instance.
> Web app uses Windows Integrated authentication.
>
> It appears that the authentication is not correctly passed to AS and that
> the app then fails.
>
> This does not seem to be the case where AS and IIS are installed on the
same
> machine.
>
> Does this sound familiar and if so are you aware of any fixes/workarounds
>
|||Hi Andrew,
I realise this post is getting quite old now, but We are experiencing the same problem here,
Did you manage to get it resolved?

Quote:

Originally posted by Andrew Wiles
In the following sceanrio
Web application uses Analysis Services to present data.
Web App (IIS) is installed on a different server to the SQL Server instance.
Web app uses Windows Integrated authentication.
It appears that the authentication is not correctly passed to AS and that
the app then fails.
This does not seem to be the case where AS and IIS are installed on the same
machine.
Does this sound familiar and if so are you aware of any fixes/workarounds

Monday, February 13, 2012

Analysis Services on the web problems

Hi,

I basically have 2 problems:

1]I am on a client Machine (Win2000 client).This is within the firewall. My SQL Server2000(Mixed mode authentication,Enterprise Edition) and Analysis server are on a Windows 2000 Advnaced Server running with IIS 5.0.This server is outside the firewall. I also have Analysis services installed on machine. I wanted to create a cube on my client machine using the SQL Server 2000 on the machine outsided the firewall.So I did the following.
[a]Created a system DSN , say TRIALDSN, on my client that points to the SQL server,with 'sa' and password as 'admin'.It worked.
[b]Then I went to Analysis services on my client, created a new
Database, and a new Data Source with the DSN name as TRIALDSN.This worked too.And THEN, I right clicked on the Cube directory and said New Cube|Editor. I am getting the message .."Connection to the 'servername-databasename' data source failed.Error:Login failed for user 'sa'.Do you want to retry? with 'Yes' and 'No' options. Can anyone help me with this error....
2]With the same setup as above, I am trying to view the cubes on the server from my client PC. I am stuck with a problem here too. This is what is my requirement.
I need a html/asp page on the server with the cube data,that a user can access from a client machine on the internet and perform drill-downs and anything else he wants. So, this is what I tried out.
On the server outside the firewall: Got the cubes onto Excel.Here I selected the Analysis Server radio button, giving the Analysis server name as the servname(that is the name of the same machine),say "ABC01". I did (and tried without too) give the username and password for the http connections.Got the data onto excel.Then I did a 'Save As Web Page' and got the excel as an html, with all the excel features still retained (although the 3D effects of the charts were lost). I then copied this html file, say, EXAMPLE.htm to the C:\inetpub\wwroot along with the msolap.asp file.
I opened the browser and gave the url for this html and everything was fine.
By the way the IIS settings are as follows:
Integrated Windows Authentication checked
Changed the default IUSR_machinename to Administrator

On the client within the firewall:Opened the browser and typed in the url as follows:
http://IP address of the server/EXAMPLE.htm
I am getting the error "The Pivot Table List 'PivotTable2' could not connect to the data source "cubename".For information about the data source, consult the creator of the file.
0x80040e4d: The operation requested failed due to security problems - the user could not be authenticated.
Some how, the data source property with the value 'ABC01' in the connection string of the html is giving the problem. What should I do?? But the whole point is, I am able to access normal html pages on the server from the client, that is , html pages that do not connect to cubes.
I am desparate for help. Thanks in advance.

AshCould you find the solution. If yes, pls. pls. let me know.

I am having the same error and I need some quick solution. My email: surbha0@.yahoo.com

Thanks a lot in advance,
Saurabh