How to prompt for username and password entry in C# / SQL ASP.NET web app?

Posted by salvationishere on Stack Overflow See other posts from Stack Overflow or by salvationishere
Published on 2010-04-24T05:16:56Z Indexed on 2010/04/24 5:23 UTC
Read the original article Hit count: 172

How do I prompt for username and password in my C#/SQL web application? This was developed in VS 2008 on a 32-bit XP. The current connection string I'm using in my web.config file is:

<add name="AdventureWorksConnectionString2" connectionString="Data Source=SIDEKICK;Initial Catalog=AdventureWorks;Persist Security Info=false; " 
        providerName="System.Data.SqlClient" />

When I select Basic Authentication it pops up the warning: "The authentication option you have chosen results in passwords being sent over the network without data encryption..." How do I choose this authentication method and still send passwords over securely?

So essentially I am looking for the most secure authentication method but that still requires users to input password?

© Stack Overflow or respective owner

Related posts about c#

Related posts about visual-studio-2008