kevaburg (3/20/2013)
Additionally, and where possible, I would leave the database with Integrated Security only. I know of very few instances where there is an absolute need to have an SQL Server Login ability. By having all your database user and group management controlled through Active Directory there is absolutely no chance of a SQL Server login being compromised.
That is the exqct opposite to my experience. In fact, having contributed in some really large corporate Enterprises as well as some one-instance shops, and lots in between, I can count on one hand the number instances not running in mixed-mode.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato