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’m using SQL Server Management Studio 2014.
I enter the password correctly.
Answer 1, authority 100%
In the SQL Server settings under Network Connections there is a Named Pipes service, you need to enable it
Answer 2
There was a similar problem, it was solved by including in the server properties, on the security tabs, SQL Server authentication
Answer 3
If, however, the Application Event Log is Error 1032 for SQL Server:
sqlservr (xxxxx) Error -1032 (0xfffffbf8) when opening log file C: \ Windows \ system32 \ LogFiles \ Sum \ Api.log.
or
sqlservr (xxxxx) Failed to open file “C: \ Windows \ system32 \ LogFiles \ Sum \ Api.log” read-only, system error 5 (0x00000005): “Access is denied.” File open operation will fail, error: -1032 (0xfffffbf8).
Then you need to give access rights to the C: \ Windows \ system32 \ LogFiles \ Sum \ folder to the user under which SQL Server is running.