Unable to login to sql server using Sql server authentication mode. Getting this error :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.) (.Net SqlClient Data Provider)

Unable to login to sql server using Sql server authentication mode. Getting this error :
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.) (.Net SqlClient Data Provider)

Asked on February 25, 2021

Answered on February 25, 2021

If you have created sql authentication user and not able to login due to this error please make sure :

Go to sql server configuration manager

Now, go to SQL Server Network configuration and select protocol for [your sql server], make sure that :

1. make sure Shared Memory Protocol is enabled

2. make sure Named Piped protocol is enabled

3. make sure TCP/IP protocol is enabled.