Re: OWC COM Object Credentials in ASP.NET and Web Services
From: Alvin Bruney [ASP.NET MVP] (www.lulu.com/owc)
Date: 03/25/05
- Next message: Alvin Bruney [ASP.NET MVP]: "Re: Alvin, Thao where are you? OWC interop problems in .Net"
- Previous message: Nick Palmer: "XMLURL parameter for an OWC 11 chart object"
- In reply to: Trevor Howe: "OWC COM Object Credentials in ASP.NET and Web Services"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Mar 2005 19:38:39 -0500
I actually thought about this for the entire day because it disturbed me
that Aspcompat would fix the issue. I have a clue but I'm not entirely
convinced that this is the sole reason.
>PS. Alvin this is a continuation of my previous post from TJCube. I am sure
> that in your research for your .Net book, you might have come across this
> problem before.
That's a wise move to make that connection (i can hear the desperation in
your voice). I did fix this issue once. I'm straining to remember what i did
(old age).
So, one thing that you can do - since i suspect this issue is because of the
request being serviced on an MTA thread pool that lacks the appropriate
permission, you will need to make sure that the account is part of the OLAP
administration account. If that doesn't fix it, here is your next step.
instead of guessing, ask the webservice to tell you what account it is being
run under. For instance, do this
[webmethod]
public string whoami()
{
//it would help to verify this line cuz it came from a tired brain
return System.Windows.Security.Principal.WindowsIdentity.Name;
}
so let's say it returns NETWORK SERVICE/vapor, you would turn around and add
the appropriate olap permissions to the vapor account. That should fix it
for you.
The reason it works in the code-behind is because impersonation forces the
executing thread to have the correct permissions, however, a web request
from a webservice would use the default account.
-- Regards, Alvin Bruney [Shameless Author Plug] The Microsoft Office Web Components Black Book with .NET available at www.lulu.com/owc _________________________ "Trevor Howe" <TrevorHowe@discussions.microsoft.com> wrote in message news:64F6B063-F8C3-44E0-BC61-21675DDAA884@microsoft.com... > Hi All > > I got hold of an article about building an OLAP Reporting APP in ASP.Net. > This article makes use of a Pivot Table on a web form and then uses a web > service to set the various properties on the Pivot table. Here is a link > to > that article: > > http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/default.aspx > > I found that the code worked fine except when I was trying to communicate > with the fieldset property of the Pivot view. It gave an interop.owc10 > unspecified error (which tells me nothing). After two weeks of > troubleshooting, and the help of one of my colleagues who knows a lot more > about .Net than me, we have narrowed this problem down to a permissions > issue > on the COM component (i.e. the Pivot table object on the web form). > > We have enabled impersonation by setting the <identity impersonate="true" > /> > in the web.config file. This allows the signed on users credentials to go > through instead of the ASPNET account. The problem was that these same > credentials were not being passed to the COM object. The solution, we > found, > was to set the ASPCOMPAT property of the web form page to true. This works > if > the code is sitting in code behind form, BUT NOT FOR WEB SERVICES. > > I need to get this up and running using web services, but web services > does > not have any ASPCOMPAT property. > > What now? Is there any better way to do this? I am pretty new to .net, so > any help would be appreciated. > > PS. Alvin this is a continuation of my previous post from TJCube. I am > sure > that in your research for your .Net book, you might have come across this > problem before. > > PPS. Jeffrey Hasan, Kenneth Tu - as authors of the article and > accompanying > source code, can't you can shed some light on this matter? > >
- Next message: Alvin Bruney [ASP.NET MVP]: "Re: Alvin, Thao where are you? OWC interop problems in .Net"
- Previous message: Nick Palmer: "XMLURL parameter for an OWC 11 chart object"
- In reply to: Trevor Howe: "OWC COM Object Credentials in ASP.NET and Web Services"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
