{{theTime}}

Search This Blog

Total Pageviews

Ms Sql Server Management Studio Error while executing a SQL. A transport-level error has occurred when sending the request to the server.

A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)


RootCause:  This error occurs when there is no active connection to the database.  

FIX:  Close the current query window and open a new query window and execute the sql.

No comments:

Mysql - java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed

Add allowPublicKeyRetrieval=true to the JDBC URL. jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false