Article ID: 982899 - Last Review: October 5, 2011 - Revision: 5.0

Forms Based Authentication in Reporting Service

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

Expand all | Collapse all

Microsoft Professional Advisory Services is a support option that provides short-term, proactive, consultative support beyond break-fix product maintenance needs. This includes working with the same technician for assistance with issues like product migration, code review, or new program development and is a remote, phone-based support option. This service is typically used for shorter engagements, and is designed for developers and IT professionals who do not require the traditional onsite consulting or sustained account management services that are available from other Microsoft support options.

For additional information on Microsoft Advisory Services, including on how to engage, refer to this Microsoft web page:

http://support.microsoft.com/gp/AdvisoryService (http://support.microsoft.com/gp/AdvisoryService)

Back to the top

Microsoft Advisory Services Engagement Scenario - Forms Based Authentication in Reporting Service

This Advisory Services scenario is designed to assist customers who are in need of help setting up Authentication in Reporting Services using Forms Based Authentication.

Forms Based Authentication (FBA) is a challenging and complex as there is no wizard available and it requires editing the web.config directly. In addition, there are a number of different authentication providers that each requires their own unique configuration. Additionally, FBA introduces additional challenges because it can be highly customized to interact with other 3rd-party authentication mechanisms.

Due to this complexity, Microsoft is offering this Advisory service related to setting up FBA with SQL Reporting Services. The Microsoft SQL Server Support Engineer will go over Reporting Services security extensions with a primary focus on Forms Authentication.

Back to the top

Microsoft Advisory Services Engagement

In Scope

Getting the sample code working on a single machine (multiple machines maybe? Not sure here)
Assisting with identifying whether the issue is related to the FBA code or to core SSRS code
Recommending potential solutions for custom FBA code

Out of Scope

Providing fixes to custom FBA code for use in production
Debugging 3rd-party FBA code
Developing an FBA solution that manages item-level security (this gets really nasty and really should go to MCS)

Back to the top

Self-Help resources for this scenario

Below is a list of self-help resources for this scenario. Microsoft Support Engineers may also use these resources during an Advisory Services engagement.

Authentication in Reporting Services 2008

http://technet.microsoft.com/en-us/library/ms152899.aspx (http://technet.microsoft.com/en-us/library/ms152899.aspx)

Configuring Authentication for Reporting Services 2005

http://technet.microsoft.com/en-us/library/bb283249(SQL.90).aspx (http://technet.microsoft.com/en-us/library/bb283249(SQL.90).aspx)

Using Forms Authentication in Reporting Services 2000

http://msdn.microsoft.com/en-us/library/aa902691(SQL.80).aspx (http://msdn.microsoft.com/en-us/library/aa902691(SQL.80).aspx)

How to: Configure Custom or Forms Authentication in Reporting Services 2008

http://msdn.microsoft.com/en-us/library/cc281383.aspx (http://msdn.microsoft.com/en-us/library/cc281383.aspx)

The Custom Security sample security extension uses Forms Authentication along with SQL Server to provide a custom security model that works with Reporting Services

http://msftrsprodsamples.codeplex.com/wikipage?title=SS2005!Security%20Extension%20Sample&referringTitle=Home&ProjectName=msftrsprodsamples (http://msftrsprodsamples.codeplex.com/wikipage?title=SS2005!Security%20Extension%20Sample&referringTitle=Home&ProjectName=msftrsprodsamples)

Back to the top