System.Data.SqlClient.SqlException:

Hello Naveen,

Try below conection string

"ConnectionString": "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True;Trusted_Connection=True;Connection Timeout=30;"

Thanks

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.

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

• 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.

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.

please check your connectionstring,

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True;"

Check if your connection string has Trusted_Connection=True added.

also, check below Video
https://www.youtube.com/watch?v=J3ERo-M0BA4