ErnesTech | SqlException: A connection was successfully established with the server, but then an error occurred during the login process.

Q: ErnesTech | SqlException: A connection was successfully established with the server, but then an error occurred during the login process.

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 <a href="https://www.ernestech.com/articles/details?title=Login-failed-for-user-.-%28Microsoft-SQL%2C-Error%3A-18456%29%26id%3D725" target="_blank" rel="noopener">related to SQL Server Login Failure Here.</a>

Question

Accepted Answer

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.

SqlException: A connection was successfully established with the server, but then an error occurred during the login process.

Gosh said:

The INSERT statement conflicted with the FOREIGN K

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableName_key". The conflict occurred in database "Database Name", table "dbo.tableName", column 'id'

How to Connect to PostgreSQL using ODBC 32bit Dsn

How to Connect to PostgreSQL using ODBC 32bit Dsn and Connection String from SQL Server

How to Use 2 CTE in a Single SQL Query - Use Temp

How to Use 2 CTE in a Single SQL Query - Use Temp Table Instead