SQL Server Performance Forum – Threads Archive
Form Authontication
Hi what is Form authontication in SQL server RegardsJoe
In what format you’re asking, give a scenario. As your question doesn’t fit to a particular topic to give an answer.
IN general there are 2 types of authentication mode to connect to a SQL server, Windows and Mixed mode.
Refer to the books online for more information. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
Hi When we are trying to register a new server under Reporting Services of SQL Server 2005;
there are basically 3 types of authentications 1.Windows authentication 2. Basic authentication
and 3. Forms authentication in which what is Forms authentication Thanks and Regards
Joe
I’ve moved to relevant Forum.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS†with no warranties for accuracy.
Thats good its more clear, refer tohttp://msdn.microsoft.com/library/?…ql2k/html/ufairs.asp?frame=true#ufairs_topic3 &http://www.aspnet101.com/aspnet101/tutorials.aspx?id=40 links for more information. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
From BOL 2005 Forms Authentication is a type of ASP.NET authentication in which an unauthenticated user is directed to an HTML form. Once the user provides credentials, the system issues a cookie containing an authentication ticket. On later requests, the system first checks the cookie to see if the user was already authenticated by the report server. Reporting Services can be extended to support Forms Authentication using the security extensibility interfaces available through the Reporting Services API. If you extend Reporting Services to use Forms Authentication, use Secure Sockets Layer (SSL) for all communications with the report server to prevent malicious users from gaining access to another user’s cookie. SSL enables clients and a report server to authenticate each other and to ensure that no other computers can read the contents of communications between the two computers. All data sent from a client through an SSL connection is encrypted so that malicious users cannot intercept passwords or data sent to a report server. Forms Authentication is generally implemented to support non-Windows accounts and authentication. A graphical interface is presented to a user who requests access to a report server, and the supplied credentials are submitted to a security authority for authentication. Forms Authentication requires that a person is present to enter credentials. For unattended applications that communicate directly with the Reporting Services Web service, Forms Authentication must be combined with a custom authentication scheme. Forms Authentication is appropriate for Reporting Services when: You need to store and authenticate users that do not have Microsoft Windows accounts, and
You need to provide your own user interface form as a logon page between different pages on a Web site.
Consider the following when writing a custom security extension that supports Forms Authentication: If you use Forms Authentication, anonymous access must be enabled on the report server virtual directory in Internet Information Services (IIS).
ASP.NET authentication must be set to Forms. You configure ASP.NET authentication in the Web.config file for the report server.
Reporting Services can authenticate and authorize users with either Windows Authentication or custom authentication, but not both. Reporting Services does not support simultaneous use of multiple security extensions.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS†with no warranties for accuracy.
Thanks a lot Joe
]]>