Thanks all for the inputs.

Found out the reason.

We have created a different service account for various applications.

And there is one service account that was used across three applications in three different servers.

And in one of the server the language setting was different:w00t:

This was the issue, we have added the "language" in our connection string, to override the differences.

Thanks all