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)

user
  • 1 Answers
user
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.



  • 0
  • 0



©2020 Edukot | Terms | Privacy | About | Contact us