Search code examples
sql-servercentos7laravel-5.5php-7.1

Laravel 5.5 connect to SQL Server using centos 7 and PHP 7

Hye, I have a new project for which need to connect laravel 5.5 with MSSQL in centos 7. Can anyone please assist me on this step by step. As i am totally beginner on this.

Thanks in Advance :)

Solution

  • Laravel supports SQLServer out of box. You can see it from config/database.php

    'sqlsrv' => [
    'driver' => 'sqlsrv',
    'host' => env('DB_HOST', 'localhost'),
    'port' => env('DB_PORT', '1433'),
    'database' => env('DB_DATABASE', 'forge'),
    'username' => env('DB_USERNAME', 'forge'),
    'password' => env('DB_PASSWORD', ''),
    'charset' => 'utf8',
    'prefix' => '',
],

    Now To add connection information, open .env, Change Database information as follows

    DB_CONNECTION=sqlsrv
DB_HOST=your-sql-server-ip
DB_PORT=1433
DB_DATABASE=your-database
DB_USERNAME=your-db-username
DB_PASSWORD=your-db-password.