The main configuration of the file ( main.php ) is as follows:
'class'=>'CDbConnection',
'connectionString'=>'mssql:host=127.0.0.1;dbname=TestSQL'
I can connect to the database successfully, but when generating a model from Yii Code Generator it tells me that the table does not exist.
Table exists? Gii generates a model based on table. First you need to create a table. If you use console version gii, then to need manage console.php config.