What could be the problem? Error text:

The connection to the server was successfully established, but then an error occurred while logging in. (provider: Shared Memory Provider, error: 0 - There are no processes at both ends of the channel.) (.Net SqlClient Data Provider)

I use SQL Server Management Studio 2014. I enter the password correctly.

  • one
    Isn't it ? - MaxU
  • Do you enter the server name correctly? Try the point . instead of name. Default gets out - Vadim Prokopchuk
  • Right, right. If you connect using Windows authorization, then everything goes well - Mikhail Znak
  • @MaxU All the same, Named Pipes has been disabled in the SQL Server settings in network connections. Thank. You can make out the answer - Mikhail Znak

1 answer 1

In the SQL Server settings in the Network connections item there is a Named Pipes service, it must be enabled

  • 2
    when connected, you can simply select the tcp protocol, then the pipe will not need to be enabled, especially if you do not use them. The protocol can be selected as follows: tcp:server,port , for example tcp:127.0.0.1,1433 - mega
  • @mega port any? - Mikhail Znak
  • the port is the one on which mssql hangs on you. 1433 - its standard port. - mega