Windows Authentication in asp.net 2005 to SQL Server?

Sorry if this sounds like a novice question but we've been using SQL Server
logins and passwords from our home made .asp login page with the whole
connection string and app wrapped in https for individual users to access
the databases on our SQL Server. I'm looking into moving towards asp.net
2005 and heard using Windows authentication is a better practice in
accessing SQL Server. I was wondering if anyone could tell me how would one
go about it in that there would be an initial login page or login pop up
(like the Windows authentication popup) where individual users would enter
in their valid windows login information which would allow them to proceed
to use the .net 2005 web app that connects to our SQL Server. Just taking a
guess...would it be good to use Windows Basic authentication where it would
pop up and the individual user can enter in their info and use https to
encrypt the database and app communication since it's in clear text?


.

Relevant Pages

  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server 2005 login issure 2
    ... My programming knowlege is pretty rusty, but if you installed SQL Server ... if you installed with Windows Authentication and then ... ALTER LOGIN sa ENABLE; ... > If by any change you have read my original post titled "SQL Server 2005 ...
    (microsoft.public.sqlserver.connect)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)