Why Windows Authentication?

From: Jason Mauss (jason.mauss_at_nospamgmail.com)
Date: 03/29/05


Date: Tue, 29 Mar 2005 10:33:36 -0800

Most of the security-related things I read about SQL Server says you should
run Windows Authentication only. Why is that?

If you run Windows Authentication only, does that stop you from implementing
application roles and stuff like that?