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

testsql.php

<?php   
 
    echo "Mengakses SQL Server : ";
     
    $serverName = "192.168.0.5\sql2008r2";
    $connectionOptions = array('Database'=>'RETAIL', 'UID'=>'sqluser', 'PWD'=>'12345');
 
    $conn = sqlsrv_connect( $serverName, $connectionOptions);
    if( $conn === false )
    {
        echo "Could not connect.\n";
        die( print_r( sqlsrv_errors(), true));
    }
    else {
        echo "koneksi berhasil..!";
        echo "Data item :";
         
        $tsql = "select ITM_CD,ITM_NAME,PRICE from dbo.RETAIL_ITEM ";
        $result = sqlsrv_query($conn, $tsql);
       
        while($row = sqlsrv_fetch_array($result))
        {
          echo($row['ITM_CD'] . ', '.
          $row['ITM_NAME'] . ', '.
          $row['PRICE'].'<br>');
        }
       
        sqlsrv_close($conn);
    }
  
?>