System.Data.SqlClient.SqlException:

Question

System.Data.SqlClient.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.)'

Vishal Yelve · Answer

Check if your connection string has Trusted_Connection=True added. also, check below Video https://www.youtube.com/watch?v=J3ERo-M0BA4

Tuhin Paul · Answer

string connectionString = "Data Source=localhost\SQLEXPRESS;Initial Catalog=MyDatabase;Integrated Security=True"; // Windows Authentication // OR string connectionString = "Data Source=192.168.1.100;Initial Catalog=MyDatabase;User ID=myUsername;Password=myPassword"; // SQL Server Authentication

Tuhin Paul · Answer

If the SQL Server is on a different machine, verify that your firewall allows incoming connections on the TCP port used by SQL Server (typically 1433). Configure firewall rules to allow connections from your application's machine.

Tuhin Paul · Answer

The error message System.Data.SqlClient.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.) indicates an issue during the login process after your application successfully connected to the SQL Server instance.

Jignesh Kumar · Answer

please check your connectionstring, Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True;"

Mudzakkir Toha · Answer

That is already defined here with full of solutions. https://stackoverflow.com/questions/34430550/a-connection-was-successfully-established-with-the-server-but-then-an-error-occ Sometime, connection string must use: Trusted_Connection=true;TrustServerCertificate=True Or some specific configurations. You can try one of it until you success using get your current environment.

Jaimin Shethiya · Answer

Hello Naveen, Try below conection string "ConnectionString": "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True;Trusted_Connection=True;Connection Timeout=30;" Thanks

System.Data.SqlClient.SqlException:

Answers (7)