Showing posts with label samples. Show all posts
Showing posts with label samples. Show all posts

Thursday, March 29, 2012

Credentials and ReportViewer

I'm building a simple report request page that makes use of the
reportviewer found in the samples. From the web server that hosts
this page, I'd like to impersonate a user to gain access to RS running
on another server. I've not been able to find instructions how how to
do this. It appears that ReportViewer makes use of the RS web service
but does not expose anything that allows passing along credentials.
I'm sure I'm missing something obvious so sorry in advance.Mark,
The ReportViewer sample control doesn't use the RS Web service. Instead, it
uses URL addressibility by firing an HTTP-GET request on the client side
(IFRAME) to the Report Server. This means, that the control requires direct
access to the Report Server. If the default Windows-based security is used,
the Report Server will see the incoming request under the credentials of the
interactive user, so no need of impersonating the user.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com : http://tinyurl.com/3l49j
Home page and blog: http://www.prologika.com/
----
"MarkMurphy" <murphy@.murphysw.com> wrote in message
news:e061eb57.0408261430.289dc804@.posting.google.com...
> I'm building a simple report request page that makes use of the
> reportviewer found in the samples. From the web server that hosts
> this page, I'd like to impersonate a user to gain access to RS running
> on another server. I've not been able to find instructions how how to
> do this. It appears that ReportViewer makes use of the RS web service
> but does not expose anything that allows passing along credentials.
> I'm sure I'm missing something obvious so sorry in advance.

Saturday, February 25, 2012

Creating new connection manager types

Hi,
Wanted to know how one can write new connection manager types, and, additionally, if there exist any code samples that show how this can be done. I searched through BOL but could not locate any.
I basically work with C++ and was curiuos if code samples exist in it? I have worked with a couple of ETL tools (or 'platforms' should I say) before, but never with SSIS.
Would really appreciate it if someone could help me out here.We're working on providing some samples for custom connection managers. Writing them in native code isn't supported this release, but in managed it is. The pattern is the same as for custom tasks. Derive from the base connection manager type in the Microsoft.SQLServer.ManagedRuntime assembly and override AcquireConnection.
This will get you the super simple connection manager.|||is there any update on this one? a sample would be rather nice?

Creating new connection manager types

Hi,
Wanted to know how one can write new connection manager types, and, additionally, if there exist any code samples that show how this can be done. I searched through BOL but could not locate any.
I basically work with C++ and was curiuos if code samples exist in it? I have worked with a couple of ETL tools (or 'platforms' should I say) before, but never with SSIS.
Would really appreciate it if someone could help me out here.We're working on providing some samples for custom connection managers. Writing them in native code isn't supported this release, but in managed it is. The pattern is the same as for custom tasks. Derive from the base connection manager type in the Microsoft.SQLServer.ManagedRuntime assembly and override AcquireConnection.
This will get you the super simple connection manager.|||is there any update on this one? a sample would be rather nice?