A connection was successfully established with the server, but then an error occurred during the pre-login handshake.

Question

A connection was successfully established with the server, but then an error occurred during the pre-login handshake.

suresh tanukula 15

I am getting below exception for database connection with MAUI android emulator. Can you please help us to resolve issue.

Microsoft.Data.SqlClient.SqlException: 'A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)'

My connection string:

connString = "Data Source=;Database=;User Id=;Password=***;Encrypt=True;TrustServerCertificate=True";

Exception:

-		$exception	{Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AndroidCrypto+SslException: Exception of type 'Interop+AndroidCrypto+SslException' was thrown.
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.<ForceAuthenticationAsync>d__146`1[[System.Net.Security.SyncReadWriteAdapter, System.Net.Security, Version=7.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a]].MoveNext()
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at System.Net.Security.SslStream.AuthenticateAsClient(String targetHost, X509CertificateCollection clientCertificates, SslProtocols enabledSslProtocols, Boolean checkCertificateRevocation)
   at Microsoft.Data.SqlClient.SNI.SNITCPHandle.EnableSsl(UInt32 options) in D:\a\_work\1\s\src\Microsoft.Data.SqlClient\netcore\src\Microsoft\Data\SqlClient\SNI\SNITcpHandle.cs:line 615
   at ESCMSMauiApp.Views.GetScanData.GetHSHData(Int64 hologramnumber) in C:\Users\stanukula\source\repos\ESCMSMauiApp\ESCMSMauiApp\Views\GetScanData.cs:line 34
   at ESCMSMauiApp.Views.HologramScan.GetHologramData() in C:\Users\stanukula\source\repos\ESCMSMauiApp\ESCMSMauiApp\Views\HologramScan.xaml.cs:line 37
   at ESCMSMauiApp.Views.HologramScan.Button_Clicked(Object sender, EventArgs e) in C:\Users\stanukula\source\repos\ESCMSMauiApp\ESCMSMauiApp\Views\HologramScan.xaml.cs:line 56
   at Microsoft.Maui.Controls.Button.Microsoft.Maui.Controls.Internals.IButtonElement.PropagateUpClicked() in D:\a\_work\1\s\src\Controls\src\Core\Button.cs:line 278
   at Microsoft.Maui.Controls.ButtonElement.ElementClicked(VisualElement visualElement, IButtonElement ButtonElementManager) in D:\a\_work\1\s\src\Controls\src\Core\ButtonElement.cs:line 85
   at Microsoft.Maui.Controls.Button.SendClicked() in D:\a\_work\1\s\src\Controls\src\Core\Button.cs:line 253
   at Microsoft.Maui.Controls.Button.Microsoft.Maui.IButton.Clicked() in D:\a\_work\1\s\src\Controls\src\Core\HandlerImpl\Button\Button.Impl.cs:line 24
   at Microsoft.Maui.Handlers.ButtonHandler.OnClick(IButton button, View v) in D:\a\_work\1\s\src\Core\src\Handlers\Button\ButtonHandler.Android.cs:line 153
   at Microsoft.Maui.Handlers.ButtonHandler.ButtonClickListener.OnClick(View v) in D:\a\_work\1\s\src\Core\src\Handlers\Button\ButtonHandler.Android.cs:line 174
   at Android.Views.View.IOnClickListenerInvoker.n_OnClick_Landroid_view_View_(IntPtr jnienv, IntPtr native__this, IntPtr native_v) in /Users/runner/work/1/s/xamarin-android/src/Mono.Android/obj/Release/net7.0/android-33/mcw/Android.Views.View.cs:line 2285
   at Android.Runtime.JNINativeWrapper.Wrap_JniMarshal_PPL_V(_JniMarshal_PPL_V callback, IntPtr jnienv, IntPtr klazz, IntPtr p0) in /Users/runner/work/1/s/xamarin-android/src/Mono.Android/Android.Runtime/JNINativeWrapper.g.cs:line 121
ClientConnectionId:7e615876-689c-4f43-b813-b6b9968c9a6b
Error Number:-2146893019,State:0,Class:20}	Microsoft.Data.SqlClient.SqlException

Fabio Caruso 90 Reputation points

2023-08-10T17:43:32.6366667+00:00

If You read here: https://github.com/dotnet/SqlClient/issues/1479

You can see that other users have the same problem.

You could change Microsoft.Data.SqlClient to System.Data.SqlClient

to see if it works, but I have read that could be security problems because System.Data.SqlClient isn't regulary updated.

Probably the best advice I have read is to add the voice:

MultiSubnetFailover=True;

to your connection string, and to change the voice: Database=...; with Initial Catalog=...;
suresh tanukula 15 Reputation points

2023-08-11T05:23:44+00:00

Thanks for your response,

I was ran in to this issue for both System.Data.SqlClient and Microsoft.Data.SqlClient on Android 13.0 - API 33.
MultiSubnetFailover flag set to true and changed Database to Initial Catalog=...; are not helped for me.
On Windows work as expected only issue with Android MAUI Application.

I got an warning message like when using System.Data.SqlClient

Net7.0-android is not available.

Exception When using System.Data.SqlClient:

Severity Code Description Project File Line Suppression State

Error CS1069 The type name 'SqlConnection' could not be found in the namespace 'System.Data.SqlClient'. This type has been forwarded to assembly 'System.Data.SqlClient, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' Consider adding a reference to that assembly.-ESCMSMauiApp (net7.0-android).

server version:
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19044: ) (Hypervisor)

Here is my exception message:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught).

Please suggest any other possible ways to fix the issue.

Thanks.

3 answers

Your answer

Fabio Caruso 90 Reputation points

2023-08-10T17:43:32.6366667+00:00

If You read here: https://github.com/dotnet/SqlClient/issues/1479

You can see that other users have the same problem.

You could change Microsoft.Data.SqlClient to System.Data.SqlClient

to see if it works, but I have read that could be security problems because System.Data.SqlClient isn't regulary updated.

Probably the best advice I have read is to add the voice:

MultiSubnetFailover=True;

to your connection string, and to change the voice: Database=...; with Initial Catalog=...;
suresh tanukula 15 Reputation points

2023-08-11T05:23:44+00:00

Thanks for your response,

I was ran in to this issue for both System.Data.SqlClient and Microsoft.Data.SqlClient on Android 13.0 - API 33.
MultiSubnetFailover flag set to true and changed Database to Initial Catalog=...; are not helped for me.
On Windows work as expected only issue with Android MAUI Application.

I got an warning message like when using System.Data.SqlClient

Net7.0-android is not available.

Exception When using System.Data.SqlClient:

Severity Code Description Project File Line Suppression State

Error CS1069 The type name 'SqlConnection' could not be found in the namespace 'System.Data.SqlClient'. This type has been forwarded to assembly 'System.Data.SqlClient, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' Consider adding a reference to that assembly.-ESCMSMauiApp (net7.0-android).

server version:
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19044: ) (Hypervisor)

Here is my exception message:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught).

Please suggest any other possible ways to fix the issue.

Thanks.

Answer 1

İsmail Ekşi 0

 Thanks for your response but...

 public static string strConnect = @"Data Source = MSSQLSERVER2019;
                                      Initial Catalog=Ovit_Tecno;
                                      Persist Security Info=True;
                                      User ID = Ovit_Tecno; 
                                      Password=xxx;
                                      Connect Timeout = 30; 
                                      Encrypt=False;
                                      TrustServerCertificate=True;
                                      Application Intent = ReadWrite;
                                      MultipleActiveResultSets=false; 
                                      MultiSubnetFailover=True;
                                      Application Name=Ovit_Software;
                                      Pooling=True;";

this is my connection string and I tried several like this following command by many users
none of them worked

Tatyana Baurina 0

I've used this connection string:

"DefaultConnection": "Server=127.0.0.1;Initial Catalog=boilerplate_db;MultipleActiveResultSets=true;User ID=sa;Password=*****;Encrypt=True;TrustServerCertificate=True;Connection Timeout=30;",

Works as it should do

Georyitt Gorayeb 0 Reputation points

2025-02-27T19:40:00.24+00:00
After extensive testing, I managed to get .NET Core 6 working with SQL Server 2014 on Debian using the following dockerized configuration:

FROM

The key aspects that made it work were modifying the OpenSSL configuration to support older TLS versions and setting the appropriate environment variables for TLS protocol compatibility.

Answer 2

Bruce (SqlWork.com) 84,061

Android and iOS do not support TrustServerCertificate. Neither O/S supports overriding certificate verification.

If android apps are going to access Sqlserver directly rather than webapi proxy, you should buy a trusted certificate for the Sqlserver.

if you want to use self signed certificates, then see the android procedures to load and trust a certificate.

0 comments

Answer 3

Javier Villegas 905 MVP

Hello

have you tried to connect to this SQL Server using SSMS ? See if you get the same error message. If that´s the case then make sure that firewall in not blocking any SQL ports between client and server

Configure the Windows Firewall to allow SQL Server access

suresh tanukula 15 Reputation points

2023-08-11T05:47:58.97+00:00

Thanks for Your response,

I am getting same error and also checked firewall is not blocking sql ports showing listening only.

Sql server version:
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19044: ) (Hypervisor)

On Windows work as expected only issue with Android MAUI Application.

Android version:

Android 13.0 - API 33.

Please suggest any other possible ways to fix the issue.

Thanks.
Dave Anderson 6 Reputation points

2023-08-13T19:51:11.0466667+00:00

SSMS access is fine as is MAUI windows. This issue is with MAUI Android.

Share via

A connection was successfully established with the server, but then an error occurred during the pre-login handshake.

3 answers

Your answer