How to connect sql server with yii2?

@darion 

To connect SQL Server with Yii2, follow these steps:

1. Install the required SQL Server extension: You need to install the yiidbmssql extension to connect to SQL Server. You can use Composer to install it by running the following command in your project directory:

1

composer require --prefer-dist yiisoft/yii2-mssql

1. Configure the database connection: Open the config/db.php file in your project directory and update the class, dsn, username, and password parameters according to your SQL Server configuration. Here's an example configuration:

1
2
3
4
5
6
7

return [
    'class' => 'yiidbConnection',
    'dsn' => 'sqlsrv:Server=localhost;Database=mydatabase',
    'username' => 'myusername',
    'password' => 'mypassword',
    'charset' => 'utf8',
];

1. Update the configuration file: Open your application's config/web.php or config/console.php file and update the database component with the newly configured connection:

1
2
3
4

'components' => [
    'db' => require __DIR__ . '/db.php',
    // other components...
],

1. Test the connection: You can test the connection by executing a SQL query. For example, you can add the following code snippet to your controller action:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

use yiidbQuery;

public function actionTestConnection()
{
    $query = new Query;
    $rows = $query->select('*')
        ->from('mytable')
        ->limit(10)
        ->all();

    print_r($rows);
}

When you access the action URL, it should display the first 10 rows from the 'mytable' table.

That's it! You have successfully connected SQL Server with Yii2.