Question: How do you resolve, SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Answer: If you are developing in Asp.Net Core, you will have to include User ID="YourDatabaseUserName"; Password="YourPassword" in the connection string.

See another article related to SQL Server Login Failure Here.