Update pada : folder_aplikasi/protected/config/main.php

// PDO MSSQL

‘db’=>array(

// ‘class’=>’application.components.MyMsSqlConnection’,

// old MS PDO + MSSQL 2000:

//’connectionString’ => ‘mssql:host=HOSTNAME\SQLEXPRESS;dbname=Client’,

// new MS PDO + MSSQL 2005 2008

‘connectionString’ => ‘sqlsrv:Server=HOSTNAME\SQLEXPRESS;Database=Client’,

‘username’ => ‘sa’,

‘password’ => ‘111’,

‘charset’ => ‘GB2312’,

‘tablePrefix’ => ‘tbl_’,

),

Sumber : http://www.yiiframework.com/wiki/192/config-use-ms-sql-server-2005-2008/