RE: identity impersonate in Sharepoint 2003

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Richard Irwin (RichardIrwin_at_discussions.microsoft.com)
Date: 11/10/04 

Date: Wed, 10 Nov 2004 05:54:04 -0800

Thanks Mike

We already handoff the web service request itself to another assembly.

We wish to connect to the SQL Server Reporting Services using the logged on
credentials so as to enable only certail reports to be viewed by certain
users.

This seems like a Catch 22 and we will have to control the users viewable
reports from the web part itself, like medicine, it doesn't taste nice but it
cures you for the moment.

Richard

"Mike Linster" wrote:

> Richard,
>
> You have run into an SPS gotcha. the way we have handled this feature / bug
> is to create a utilities class that includes impersonation. We pass that
> class what we need it to do, it goes out and runs the process and returns the
> result to the end user. That way you won't loose the user context yhou are
> running under. The class simply accepts tasks completes them and returns the
> completed task to you. Impersonation within SharePoint is tricky and risky,
> i'd develop a worker process that you can simply hand off tasks to and will
> complete handing you back the result. I know it isn't clean but unfortunatly
> it is the path we had to go to get the results we were looking for.
>
> HTH
> Mike
>
> "Richard Irwin" wrote:
>
> > I am trying to connect to SQL Server Reporting Services Web Service form a
> > Web Part but am recieving
> > System.Net.WebException: The request failed with HTTP status 401:
> > Unauthorized.
> > when I try to use <identity impersonate="true" />
> > however if I set <identity impersonate="true" userName="domain\username"
> > password="password"/> all works fine.
> >
> > Some how the Windows logged on user account details are not being
> > impersonated. Machine and user account runing Sharepoint have been Delegated
> > in AD.
> >
> > Richard
> >
> > Also all worked fine on a freshly build Win2k3 box without SharePoint 2003
> > for a stanard aspx page accessing SQL Server Reporting Services Web Service,
> > this does not work after SharePoint 2003 installed.
> >
> >

Relevant Pages

  • Re: Automatically Printing from SQL Reporting services
    ... Local printing will be in the next service pack. ... MVP SQL Server Reporting Services ... "Ernie" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Migrating existing SQL application to sharepoint
    ... Investigate SQL Server Reporting Services for your reporting needs, ... on a server and refer to it using a web viewer part. ... > way to migrate this application into sharepoint? ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: .NET Error message
    ... 1.Microsoft SQL Server Reporting services 2005 ... 2.Install Microsoft SQL Server 2005 SP1 ...
    (microsoft.public.sqlserver.setup)
  • Re: Borland is neglecting Delphi for Win32 badly
    ... a large part of SQL Server Reporting Services 2000 is ... written in managed code ... assuming Microsoft can ever bring itself to release ...
    (borland.public.delphi.non-technical)