SQLSTATE[08001] - Named Pipes Provider - Laravel

Asked

Viewed 882 times

1

I’m getting an error when connecting the application to the bank.

The file . env is configured correctly with the database settings, the error I have as return:

SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [67]. (SQL: select top 1 * from [stakeholders] where [login] = rmendes)

The project is done in Laravel, and the bank is in localhost.

I use the SQL SERVER MANAGEMENT STUDIO 2014

Screenshot of the browser error.... Named Pipes Provider

Could that be the cause of my problem? Pipes named

php sql-server laravel xampp

  • To fix the error, simply enable the communication option via TCP/IP protocol of SQL Server.

  • How are you doing to "upload the application"? Just copied the files to the right places?

  • is that this bank was in production ,aew for me to do the tests I took a backup and created a location , localhost sqlexpress configured in the.env file of the Standard and even in the database.php of the Standard itself pointing to the local bank... and I go up using the php artisan serve ... that’s it

1 answer

2


Basically you should enable the possibility of remote connection, the protocol Named-Pipes and TCP/IP as well as the SQL Browser service. (in theory)

But try the following:

Temporarily disable Windows Firewall and test again:

inserir a descrição da imagem aqui

Make sure that Netbios is enabled in the TCP/IP settings of the network adapter you are using:

inserir a descrição da imagem aqui

Make sure that SQL Server protocols are enabled through SQL Server Configuration Manager:

inserir a descrição da imagem aqui

Also try a combination of two or more options above.

  • Darlei . The same error still continues .. and I also made the combinations ,to see if even the error changed and yet ,...

  • This type of error has to do with the Laravel or sql server configuration ?? just to take this question my

  • Everything indicates Laravel tries to make the connection to the server but can not. The most common reason for this error is that this connection attempt failed because this DSN or ODBC data source tried to make a connection using the TCP / IP Net-Library sockets, which is Dbmssocn.dll. Since SQL Server is not listening to incoming connections to TCP/IP sockets clients, the connection fails.

  • aew i search as in google?? how to configure sql TCP/IP sockets ?

  • Take a look here -> https://support.microsoft.com/pt-br/help/195566/prb-odbc-connection-failed-sqlstate-08001-dbmssocn

  • 1

    I asked the DBA Master to create a test environment for me,.

Show 1 more comment

Browser other questions tagged php sql-server laravel xampp

You are not signed in. Login or sign up in order to post.