Mengakses SQL Server 2008R2 dari PHP menggunakan CodeIgniter, silahkan lihat di http://w4w417.wordpress.com/2016/01/09/mengakses-sql-server-2008r2-dari-php-menggunakan-codeigniter/

database.php

<?php


// Bagian yang perlu disesuaikan dengan konfigurasi SQL Server
$active_group = 'default';
$query_builder = TRUE;
 
$db['default'] = array(
    'dsn'   => '',
    'hostname' => '192.168.0.5\SQL2008R2', //hostname dan instance name dari SQL Server kita
    'username' => 'sqluser',
    'password' => '12345',
    'database' => 'RETAIL', //nama database yang akan kita akses
    'dbdriver' => 'sqlsrv', //nama driver yang kita pergunakan (sqlsrv untuk SQL Server 2008R2)
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => FALSE,
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

?>

Home.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
 
class Home extends CI_Controller {
 
    public function index()
    {
        $this->db = $this->load->database('default', TRUE);
         
        $sql = "select ITM_CD,ITM_NAME,PRICE from dbo.RETAIL_ITEM ";
         
        $query = $this->db->query($sql);
         
        if($query){ 
            if ($query->num_rows() > 0)
            {
            foreach ($query->result_array() as $row)
            {
                    $items[] = $row;            
                }
            $data['itemslist'] = $items;
        }
    }
         
        $this->load->view('page',$data);
    }
}
?>

page.php

<center>Daftar Item-item :</center>
<br>
<table width="800" align="center" cellpadding="2" cellspacing="1" border="1">
    <tr bgcolor="#DBDBDB">
        <td align="center">ITEM CODE</td>
        <td align="center">ITEM NAME</td>
        <td align="center">PRICE</td>
    </tr>
    <?php
    foreach($itemslist as $line=>$item){
        ?>
        <tr>
            <td style="padding-left:5px;"><?php echo $item['ITM_CD']; ?></td>
            <td style="padding-left:5px;"><?php echo $item['ITM_NAME']; ?></td>
            <td align="right" style="padding-right:5px;"><?php echo $item['PRICE']; ?></td>
        </tr>
        <?php
    }
    ?>
</table>