title: CakePHP SQL Server Windows Authentication
body: <p>I have CakePHP connecting to a SQL Server database using standard SQL Server authentication.  If I want to connect via Windows Authentication instead has anyone tried this?</p>
  
  <p>Firstly I think it requires using the <a href="http://blogs.msdn.com/b/brian_swan/archive/2010/02/10/sql-server-driver-for-php-understanding-windows-authentication.aspx" rel="nofollow noreferrer">SQL Server drivers</a> i.e. not the standard MSSQL PHP drivers so that PHP itself can use Windows Authentication.  Then its the issue of replacing all the places in CakePHP where it assumes that its using the /app/core/database.php config file.</p>
  
  <p>Has anyone tried either using the SQL Server drivers with CakePHP or better yet tried Windows Authentication?  Or simply maybe its just not worth the hassle.</p>