Any security related reasons to prefer Windows Authentication over Sql Server Authentication?
An example, separation of duties

On a web server, the password for the service account is only known by one team. It isn't required to lie around in web.config or source control.


One team sets up the IIS App Pool (password is known here)
One team deploys code
One team manages the SQL Server Instance


If you want to pass an audit where PCI or SoX is involved, then you need to have this