Codeigniter with MSSQL(sqlsrv) on Windows

Environment

• MSSQL 2008 R2
• PHP 5.4
• Xampp

Prepare .dll file

• php_pdo_sqlsrv_54_ts.dll
• php_sqlsrv_54_ts.dll

How to

• stop webserver
• cody .dll file to /[path_to_php_folder]/php/ext
• edit php.ini add this line

extension=php_pdo_sqlsrv_54_ts.dll
extension=php_sqlsrv_54_ts.dll

• start webserver
• edit database.php at /application/config/database.php and save

$db[‘default’] = array(
 ‘dsn’ => ‘’,
 ‘hostname’ => ‘YOUR_INSTANCE_NAME’,
 ‘username’ => ‘YOUR_USERNAME’,
 ‘password’ => ‘YOUR_PASSWORD’,
 ‘database’ => ‘YOUR_DATABASE_NAME’,
 ‘dbdriver’ => ‘sqlsrv’,
 ‘dbprefix’ => ‘’,
 ‘pconnect’ => FALSE,
 ‘db_debug’ => (ENVIRONMENT !== ‘production’),
 ‘cache_on’ => FALSE,
 ‘cachedir’ => ‘’,
 ‘char_set’ => ‘utf8’,
 ‘dbcollat’ => ‘utf8_general_ci’,
 ‘swap_pre’ => ‘’,
 ‘encrypt’ => FALSE,
 ‘compress’ => FALSE,
 ‘stricton’ => FALSE,
 ‘failover’ => array(),
 ‘save_queries’ => TRUE
);