How to connect Laravel and Microsoft sql server

Asked Feb 18 '16 at 00:59

Active Feb 18 '16 at 01:01

Viewed 2,532 times

Here is my configuration in laravel:

'default' => env('DB_CONNECTION', 'sqlsrv'),
'sqlsrv' => [
            'driver'   => 'sqlsrv',
            'host'     => env('DB_HOST', '192.168.1.15'),
            'database' => env('DB_DATABASE', 'gaspos'),
            'username' => env('DB_USERNAME', 'vlado'),
            'password' => env('DB_PASSWORD', 'test1'),
            'charset'  => 'utf8',
            'prefix'   => '',
        ],

And when I try:

php artisan migrate, I get:

  [PDOException]
  SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Prov
  ider: Could not open a connection to SQL Server [2].

Anyone know what is porblem?

edited Feb 18 '16 at 01:01

asked Feb 18 '16 at 00:59

Vladimir Djukic

2,042
7
29
60

Did you put all your SQL Serve credentials in `.env` file? – Jilson Thomas Feb 18 '16 at 01:01
1

Have you checked [this](https://support.microsoft.com/en-us/kb/195566)? – Rao Feb 18 '16 at 01:25
2

Does this help? http://stackoverflow.com/questions/9945409/how-do-i-fix-the-error-named-pipes-provider-error-40-could-not-open-a-connec – Liesel Feb 18 '16 at 02:03
hello, how are you? I wanna also laravel+microsoft sql server configuration. Do you fix this problem? If yes, can you help me, please? – GlistenSTAR Apr 08 '21 at 08:47

How to connect Laravel and Microsoft sql server

0 Answers0