How to fix connectivity issue between asp.net web ( On prem ) to azure sql

Question

How to fix connectivity issue between asp.net web ( On prem ) to azure sql

Anil Babu Ravi 5

Microsoft.Data.SqlClient.SqlException (0x80131904): An error occurred while sending the request. ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.

SSingh-MSFT 16,276 Reputation points

2023-08-16T04:11:00.3466667+00:00

Hi
Anil Babu Ravi •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

1 answer

Your answer

SSingh-MSFT 16,276 Reputation points

2023-08-16T04:11:00.3466667+00:00

Hi
Anil Babu Ravi •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Answer 1

Alberto Morillo 34,651 MVP

Please make sure the connection string has the following settings included:

Encrypt=True;TrustServerCertificate=True;Connection Timeout=30;"

Anil Babu Ravi 5 Reputation points

2023-08-11T09:07:14.6233333+00:00

does not work.

below other messages

Microsoft.Data.SqlClient.SqlException (0x80131904): Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated).

Error code 0xparsing_wstrust_response_failed

Microsoft.Data.SqlClient.SqlException (0x80131904): An error occurred while sending the request. ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it
SSingh-MSFT 16,276 Reputation points

2023-08-11T12:48:49.1633333+00:00

Hi
Anil Babu Ravi •,

Please look at a similar Q&A thread with this exception which may help you:

https://learn.microsoft.com/en-us/answers/questions/1135652/webexception-unable-to-connect-to-the-remote-serve

Let us know if this solves your problem else, we will need more details about the configuration to investigate further.

Thanks
Anil Babu Ravi 5 Reputation points

2023-08-16T06:52:03.96+00:00

Issue is not solved.
Anil Babu Ravi 5 Reputation points

2023-08-16T06:53:30.94+00:00
SSingh-MSFT 16,276 Reputation points

2023-08-16T07:33:21.0733333+00:00

Hi
Anil Babu Ravi •,

This is strange and not expected. I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you. Thanks
Anil Babu Ravi 5 Reputation points

2023-08-16T07:45:50.31+00:00

Yes. I have raised the support ticket waiting for responses.
Oury Ba-MSFT 20,716 Reputation points Microsoft Employee

2023-08-16T17:23:55.3666667+00:00

Anil Babu Ravi

Please kindly share the support ticket here so we can make sure it is routed correctly.

Regards,

Oury

Share via

How to fix connectivity issue between asp.net web ( On prem ) to azure sql

1 answer

Your answer