How to use Windows Authentication (SSPI) with MS SQL?

Yii 1.1 General Discussion
1

[font=Tahoma, Verdana][size=2]How to use Windows Authentication (SSPI) with MS SQL, and be able audit log user’s activity as well[/size][/font]

2

mssql.secure_connection = On, and what else