title: How to connect Codeigniter with MSSQL (SQL Server)?
body: <p>My server use Windows Server with MSSQL 2012. While I am use OS X (El Capitan) with XAMPP (Apache) for Mac and develop website using Codeigniter 2.2.0.</p>
  
  <p>Here is my configuration :</p>
  
  <pre><code>$active_group = 'my_mssql';
  $active_record = TRUE;
  
  $db['my_mssql']['hostname'] = 'xx.xx.xx.x';
  $db['my_mssql']['username'] = 'wow_queue';
  $db['my_mssql']['password'] = 'wow12345';
  $db['my_mssql']['database'] = 'queue_sys';
  $db['my_mssql']['dbdriver'] = 'mssql';
  $db['my_mssql']['dbprefix'] = '';
  $db['my_mssql']['pconnect'] = TRUE;
  $db['my_mssql']['db_debug'] = TRUE;
  $db['my_mssql']['cache_on'] = FALSE;
  $db['my_mssql']['cachedir'] = '';
  $db['my_mssql']['char_set'] = 'utf8';
  $db['my_mssql']['dbcollat'] = 'utf8_general_ci';
  $db['my_mssql']['swap_pre'] = '';
  $db['my_mssql']['autoinit'] = TRUE;
  $db['my_mssql']['stricton'] = FALSE;
  </code></pre>
  
  <p>but the results is :</p>
  
  <p><img src="https://i.stack.imgur.com/sfqrj.png" alt="1">
  <br />
  Are my settings be wrong?</p>
  
  <p>I just want to be able to connect to that server. Does anyone have any advice on solving this?</p>