Hi,
Thanks for your posting.
From your descriptions, I understood you would like to know how to use LDAP
for authentication in SQL Server Reporting Services. If I have
misunderstood your concern, please feel free to point it out.
Based on my knowledge, Reporting Services retrieves report data using Data
Processing Extensions. Data Processing Extensions use ADO.NET managed
providers. Reporting Services by default provides extensions to retrieve
data from the following data sources:
- SQL Server 2000
- SQL Server 7.0
- SQL Server 2000 Analysis Services
- Oracle
- ODBC data sources
- OLE DB data sources
Microsoft does not provide support for Reporting Services to use LDAP
directly as the data source by default. Since Reporting Services is
extensible, you could create extensions that retrieve data from additional
data sources such as LDAP by yourself. Please refer to the following
article on how to create a Data Processing Extension for Reporting Services:
Implementing a Data Processing Extension:
http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/
htm/rsp_prog_extend_dataproc_5c2q.asp
However, as to how to implement a Data Processing Extension is quite beyond
our supportability as we are not familiar with the specific application
logic on your side. And an incident of Web Response support is intended to
solve a specific issue such as Server hang, Installation failure, etc.
There are also some third-party vendors that implement an ODBC data source
for
LDAP. You could find the product of Persistent Systems Private Limited in
the "Component Partners for Reporting Services" web page on Microsoft Web
Site:
<http://www.microsoft.com/sql/reporting/partners/component.asp>
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

Signature
This posting is provided "AS IS" with no warranties, and confers no rights.
Puddy - 06 Oct 2005 09:17 GMT
Sorry if I wasn't clear - I am not looking to use LDAP as a datasource but as
a way to authenticate users and assign permissions to view reports.
I have carried out some searching and found a reference to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_
prog_extend_security_8g4m.asp
Has any one has attempted to do this before and what challenges are
Thanks
Puddy
> Hi,
>
[quoted text clipped - 51 lines]
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
Michael Cheng [MSFT] - 07 Oct 2005 06:05 GMT
Hi Puddy,
Sorry that I misunderstood it.
I understood you would like to implement custom security extension to
access LDAP authentication. If I have misunderstood your concern, please
feel free to point it out.
Based on my knowledge, we will use ReportingService.LogonUser method to do
such authentications. However, we do not have too much resource on this
topic. You may refer the articles below
Using Forms Authentication in Reporting Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/ufairs.asp
Custom Authentication provider by implementing IHttpModule, IPrincipal and
IIdentity
http://www.codeproject.com/aspnet/AspNetCustomAuth.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

Signature
This posting is provided "AS IS" with no warranties, and confers no rights.
Puddy - 07 Oct 2005 09:12 GMT
Thanks Michael
> Hi Puddy,
>
[quoted text clipped - 29 lines]
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
Michael Cheng [MSFT] - 10 Oct 2005 12:28 GMT
Hi Puddy,
You are welcome! Hope my information are useful and If you have any
questions or concerns next time, don't hesitate to let me know. We are
always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

Signature
This posting is provided "AS IS" with no warranties, and confers no rights.
Rakesh - 11 Oct 2005 02:01 GMT
Puddy,
We implemented the custom authentication using Sql Server, we had
client facing Reports and we used Forms Authentication with sql server as our
auth. source. but it should not be any different to go to LDAP for your
authentication, I used the sample code from Teo Lachev's book. Here is the
url for it.
http://www.manning.com/books/lachev/source
It was very helpful and Teo was very kind to answer some great questions,
HTH,
Rakesh
> Thanks Michael
>
[quoted text clipped - 31 lines]
> > =====================================================
> > This posting is provided "AS IS" with no warranties, and confers no rights.
WillG - 30 Dec 2005 02:52 GMT
Would you mind emailing or posting the final code?
It seems there are a LOT of questions out here about forms auth, yet few
working answers.
-Will
> Puddy,
> We implemented the custom authentication using Sql Server, we had
[quoted text clipped - 45 lines]
> > > =====================================================
> > > This posting is provided "AS IS" with no warranties, and confers no rights.