Re: Problem deploying forms authorization

Thanks for your reply HIK,

Glad that you've got some progress and the login failed error no loger
exists.

For the new problem you met, I'm not quite sure on the following behavior:


The code I wrote for authentication is run, but ignored.
<<<<<<<<<<<

I can imagine that the SQL calls are passed and executed in SQL server as
you now can correctly login SQL Server and execute query. However, what's
the behavior that means your code has been ignored?

Also, from the code you provided, it seems you haven't used the built-in
membership & role provider feature and use your own custom database and
component class for user account validation and role retrieving , correct?
Also, in the Login Control's authentication code, I found that you only use
component to do the data access and validate the account, have you also
called the Forms Authentication API to establish the forms authentication
cookie ticiet? If you haven't used the forms authentication API and are
not sure on it, you can have a look at the following articles:


#BASICS: Forms Authentication in ASP.NET 2.0
http://www.eggheadcafe.com/tutorials/aspnet/009e2e5e-5a44-4050-8233-59a0d698
44e8/basics-forms-authenticat.aspx

#Explained: Forms Authentication in ASP.NET 2.0
http://msdn2.microsoft.com/en-us/library/aa480476.aspx

#How To Implement Role-Based Security with Forms-Based Authentication in
Your ASP.NET Application by Using Visual C# .NET
http://support.microsoft.com/kb/311495/en-us

Please feel free to let me know if you have anything unclear on this.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • [Full-Disclosure] Advisory: Dark Age of Camelot - Weak encryption of network traffic exposed persona
    ... Weak encryption in game client exposed customer billing and authentication ... encryption for billing information. ... The login binary has undergone several updates since then. ...
    (Full-Disclosure)
  • Re: Cant Connect
    ... Then it's likely the authentication settings on the IIS side ... Try adding the IUSR account as a login in SQL Server ... > Cn.open CnStr ...
    (microsoft.public.sqlserver.connect)
  • Re:changing sa password / login
    ... authentication and it worked. ... >I think you might have made changes to SQL Server ... >Authentication" can not recognize SA login which is SQL ... >configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Security question ..
    ... > If you use NT authentication, a user's permissions to a database are ... Your assertion that a user's permissions are independent of the application ... Even using Access and "exploring" will require an ODBC login to SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re:changing sa password / login
    ... I think you might have made changes to SQL Server ... to make was using Mixed Authentication which will ... Authentication" can not recognize SA login which is SQL ... configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)