A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0)

Bump into this error today. Strange enough the application is able to use the same connection string to connect successfully, then failed the next. The database is configure with highly available group. 

I have TrustCertificate=true;Encrypt=true;MultisubnetFailvover=true

Yet it still breaks.


From the message itself, it is clear we not having a credential issue as we are able to connect successfully. It just can't make the connection sticks. 

Then later i found out that - we need to connect to another different dns and port number. After checking with the dba. 

So this error can be tricky, as many people suggest turning TrustCertificate=false, Encrypt=false. I guess a better way to test is basically use a sample app that opens up a connection to the database server from the box itself. 



Comments

Post a Comment

Popular posts from this blog

The specified initialization vector (IV) does not match the block size for this algorithm

Image
If you're getting  exception when trying to assigned key to a symmetric key and getting error message below :- The specified initialization vector (IV) does not match the block size for this algorithm And your code probably look like something below :- Then you need to go into debug mode and start looking into the supported size for IV as shown in diagram below :- As you can see, IV is 16 bytes, so you need to provide 16 bytes. The same goes for Key field too, if you're adding anything to it. As long as you provide a valid key size, then we're good and you're code will be ready.
Read more