My boss, a dba, is telling me there is a way to authenticate a .net web site using sql server 2005 and later. Not forms authentication, not nt authentication, not passing a sql server login in a connection string, etc., but using sql server. Apparently you can let it handle everything. I have not been able to find anything on this. Any ideas?
SQL Server Authentication is really either rolling out Forms authentication yourself or use the out-of-the-box SqlMembershipProvider. The MSDN documentation has a very comprehensive example there.