1. Install PHP: 5.3 is recommended. (All .dll files related to 5.4 won’t work!)
   http://www.php.net/downloads.php
2. Download Microsoft Drivers: Do not use 3.0, only 2.0 dll files will work!
   http://www.microsoft.com/en-us/download/details.aspx?id=20098
3. Copy drivers to “ext” folder (default in php 5.3, and can be changed in php.ini)
4. Update php.ini (Use text editor or PHP Manager)
   e.g. extension=php_pdo_sqlsrv_53_nts_vc9.dll (vc6 won’t work!)
5. Restart IIS
6. Check PDO support in phoinfo(): “sqlsrv” should be in “enable” list.
7. Connection String: sqlsrv:Server=19x.1xx.1xx.1xx;Database=lab

Here is my environment: Windows 7 + IIS 7 + SQL Server 2008 R2, PHP 5.3
Believing in latest version from MS is my fault.

Reference:

1. http://www.yiiframework.com/forum/index.php/topic/18946-how-to-connect-mssql-database/
2. http://www.php.net/manual/en/ref.pdo-sqlsrv.php
3. http://www.php.net/manual/en/ref.pdo-sqlsrv.connection.php
4. http://www.yiiframework.com/forum/index.php/topic/42723-could-not-find-driver-sqlsrv/

10/7/2014 Update

Reference:

1. http://j796160836.pixnet.net/blog/post/32652509-%5Bphp%5D-php-5.4-(for-windows)%E4%B9%8B%E5%BE%8C%E7%89%88%E6%9C%AC%E9%80%A3%E6%8E%A5microsoft-sql-s
2. http://msdn.microsoft.com/en-us/library/cc296170.aspx
3. http://www.microsoft.com/en-us/download/details.aspx?id=20098
4. Install sqlsrv extension in different windows servers (Very detailed):
   http://robsphp.blogspot.co.uk/2012/09/how-to-install-microsofts-sql-server.html
5. For Codeigniter: http://www.kaweb.co.uk/uncategorized/mssql-server-2005-and-codeigniter/
6. Complete Codeigniter for sqlsrv: (Replace files in /database/drivers/sqlsrv/)
   http://www.manjustudio.com/2013/01/09/codeigniter-mssql-sqlsrv/
   File: codeIgniter1
7. Insert and Update UTF-8 into MSSQL (Need to revise driver):
   http://stackoverflow.com/questions/22981997/insert-update-utf8-string-sql-server-codeigniter
   
   
   PHP

   function _make_unicode($value){ if(is_string($value) && $value!="NULL") return "N".$value; else return $value; } function _insert($table, $keys, $values) { foreach($values as $index => $value){ $values[$index] = $this->_make_unicode($value); } return "INSERT INTO ".$this->_escape_table($table)." (".implode(', ', $keys).") VALUES (".implode(', ', $values).")"; } function _update($table, $values, $where) { foreach($values as $key => $val) { $valstr[] = $key." = ".$this->_make_unicode($val); } return "UPDATE ".$this->_escape_table($table)." SET ".implode(', ', $valstr)." WHERE ".implode(" ", $where); }

   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

   function _make_unicode($value){     if(is_string($value) && $value!="NULL")      return "N".$value;     else      return $value; }     function _insert($table, $keys, $values) {     foreach($values as $index => $value){      $values[$index] = $this->_make_unicode($value);     }   return "INSERT INTO ".$this->_escape_table($table)." (".implode(', ', $keys).") VALUES (".implode(', ', $values).")"; }   function _update($table, $values, $where) { foreach($values as $key => $val) { $valstr[] = $key." = ".$this->_make_unicode($val); } return "UPDATE ".$this->_escape_table($table)." SET ".implode(', ', $valstr)." WHERE ".implode(" ", $where); }

   
    

Settings in PHP Manager:

Sample Code: