all groups > sql server reporting services > february 2006 >
You're in the

sql server reporting services

group:

Two Authentiation/Authroziation Methods? Windows Auth + Forms Auth


Two Authentiation/Authroziation Methods? Windows Auth + Forms Auth Chris Taylor
2/16/2006 2:53:56 PM
sql server reporting services: Hi,

Maybe this has been answered here but a question that has recently come up
is how do we use Windows Auth and Forms Auth together?

And maybe if that isn't possible, how can we publish from VS2005 with Forms
Auth enabled? Seems the only way to do so is manually upload. It would be
nice to use the VS2005 environment, especially when you have like 50+
reports.

Let me know what we can do!

Thanks!
Chris

RE: Two Authentiation/Authroziation Methods? Windows Auth + Forms Auth stcheng NO[at]SPAM online.microsoft.com
2/17/2006 12:00:00 AM
Hi Chris,

Welcome to the MSDN newsgroup.

As for FormsAuthentication and windows authenticaiton, they can not be used
together for a single reporting service instance in mix mode. This is
actually the same with ASP.NET web application since the report server
application is ASP.NET based which can only be configured to use a single
authentication mode at a time. Also, for deploying reporting service and
configure authentication mode, there is no such simplified buildin
deployment task in visual studio. Based on my understanding, the
authentication mode for reporting service is mainly configured for the
report server application, we need to do the following things basically:

1. configure the report server application to use custom
authentication(form authentication) in IIS.

2. add the custom authenitication extension classed into report server
application, need to modify the configure files.

All these tasks can not be done by visual studio task. You can refer to the
following msdn tech article on deploying forms authentication extension for
SQL server Reporting service(the thoery also applies to 2005 though be
written for 2000):

#Using Forms Authentication in Reporting Services
http://msdn.microsoft.com/library/en-us/dnsql2k/html/ufairs.asp?frame=true

Hope this helps.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)











Re: Two Authentiation/Authroziation Methods? Windows Auth + Forms Auth Chris Taylor
2/17/2006 8:42:33 AM
So are you saying its not possible to deploy with VS2005 and using forms
authentication? Is that the jist of it?


[quoted text, click to view]

Re: Two Authentiation/Authroziation Methods? Windows Auth + Forms Auth stcheng NO[at]SPAM online.microsoft.com
2/20/2006 12:00:00 AM
Yes, VS 2005 can help developed Reports and deployment them to server,
however, authentication mode is a whole server scope setting which can not
be simply configured when deploying a report. We need to manually configure
it in ReportingService's Report Server.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
AddThis Social Bookmark Button