How to fix the connection problem from .NetMaui to SQLServer with Microsoft.Data.SqlClient

Question

How to fix the connection problem from .NetMaui to SQLServer with Microsoft.Data.SqlClient

İsmail Ekşi 0

please hekp me to solve problem below..

There is a small .netMaui software connect to SqlServer. Once I run "Windows Machine", everything is fine.

Once I turn it to Android emulatr, I get error message belowe.

How can I solve it?

{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.

Anonymous

2023-11-30T08:20:32+00:00

What is your .NET version?

Are you using a self-signed certificate in your SQL server?

1 answer

Your answer

Anonymous

2023-11-30T08:20:32+00:00

What is your .NET version?

Are you using a self-signed certificate in your SQL server?

Answer 1

Olaf Helper 47,436

Authentication failed,

Are you using Windows Authentication in your connection string? That works on Windows but not on Android.

Change to SQL Authentiction instead.

İ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

Share via

How to fix the connection problem from .NetMaui to SQLServer with Microsoft.Data.SqlClient

1 answer

Your answer