Microsoft Knowledge Base Email Alertz
All KB/RSS Links  |  Hot Kb!  |  New Kb!  |  Scott Cate  |  FAQ / KB  |  Web Hosting  |  Unsubscribe  

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

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.
Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks
Article ID: 982899 - Last Review: October 5, 2011 - Revision: 5.0

Forms Based Authentication in Reporting Service

View products that this article applies to.
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
APPLIES TO
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2005 Compact Edition
  • Microsoft SQL Server Compact 3.5
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2000 Personal Edition Service Pack 3
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
Back to the top
Keywords: 
kbproadvisory kbtshoot kbnomt kbprosql kbprodeveloper KB982899
Back to the top
        

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Copyright © 2002-2007 KBALERTZ.COM.  All Rights Reserved. Terms / Privacy. Discount ASP.NET Hosting