I am Not Able to connect .NET MAUI Project with MS SQL Connection.

Question

I am Not Able to connect .NET MAUI Project with MS SQL Connection.

Muhammad hamid 6

Hi , I am Using MS SQL in .NET Maui Project and I am not able to get connected . the problem is that when i am using System.data.Sqlclient it is not showing me mssqlconnection object so I tried with Microsoft.data.mssqlclient and this time it is giving error "Connection was established but there is problem during pre login handshake " can you please give me any suggestion ,

regards M.Asad.

Jack J Jun 23,661 Reputation points Microsoft Vendor

2022-04-27T05:45:08.307+00:00

@Muhammad hamid , Currently .NET MAUI related question is not supported in Microsoft Q&A, I recommend that you could ask the question in Github.

Thanks for your understanding.
Jan Seris 11 Reputation points

2022-06-28T18:55:14.363+00:00

Hi, what Android version and what SqlClient version and what SQL Server version are you using? I am facing this issue as well.
Did it happen only on Android? For me it does not happen on Windows, only on Android
I am curious also did you get System.Data.SqlClient to work on Android? Or was it Microsoft.Data.SqlClient?

Thank you.
WMcRob 1 Reputation point

2022-07-13T06:25:17.837+00:00

I am also having this issue...has anyone figured this out?
José Alonso 0 Reputation points

2023-03-09T03:57:41.8066667+00:00

Hasta el momento, todo bien Con Maui, lo único malo son las conexiones directas a SQL Server, he utilizado la librería Microsoft.Data.SqlClient porque System.Data.SqlClient no es compatible. Pero esto únicamente ha funcionado en Windows porque en plataformas Android no se ejecuta el sql.command.

Jack J Jun 23,661 Reputation points Microsoft Vendor

2022-04-27T05:45:08.307+00:00

@Muhammad hamid , Currently .NET MAUI related question is not supported in Microsoft Q&A, I recommend that you could ask the question in Github.

Thanks for your understanding.
Jan Seris 11 Reputation points

2022-06-28T18:55:14.363+00:00

Hi, what Android version and what SqlClient version and what SQL Server version are you using? I am facing this issue as well.
Did it happen only on Android? For me it does not happen on Windows, only on Android
I am curious also did you get System.Data.SqlClient to work on Android? Or was it Microsoft.Data.SqlClient?

Thank you.
WMcRob 1 Reputation point

2022-07-13T06:25:17.837+00:00

I am also having this issue...has anyone figured this out?
José Alonso 0 Reputation points

2023-03-09T03:57:41.8066667+00:00

Hasta el momento, todo bien Con Maui, lo único malo son las conexiones directas a SQL Server, he utilizado la librería Microsoft.Data.SqlClient porque System.Data.SqlClient no es compatible. Pero esto únicamente ha funcionado en Windows porque en plataformas Android no se ejecuta el sql.command.

Answer 1

Bruce (SqlWork.com) 36,346

Microsoft.Data.SqlClient is the replacement for System.Data.SqlClient. they have the same api, but the new version is getting the new features. Not sure what you mean when you you say mssqlconnection. in both libraries its (assuming the namespace using)

using var conn = new SqlConnection(connectionString);
await conn.OpenAsync();

your error sounds like you are not using trusted certificates on the sqlserver, so need you need to add TrustServerCertificate=true; to the connection string.

Muhammad hamid 6 Reputation points

2022-04-27T04:28:37.137+00:00

Hello and thanks bro , i am using same as you told conn = new SqlConnection(String) and tried Trustcertificatet = true but it is not working still. ??
Bruce (SqlWork.com) 36,346 Reputation points

2022-04-28T20:51:49.38+00:00
is the sql server configured fr tcp/ip? try this simple powershell script to test your connection string

$conn = New-Object System.Data.SqlClient.SqlConnection $conn.ConnectionString = "Server=MyServer;Database=Sample;Integrated Security=True;TrustServerCertificate=True;" $conn.Open() $conn.Close()
SCAppCo 1 Reputation point

2022-07-08T20:07:36.087+00:00

Did you get it working? I am having the same issue with Net Maui and Microsoft.Data.SQLClient. I cannot get it to connect. I keep getting the following two errors... I am trying to connect to a SQL Server on our local network, and I have a valid DigiCert installed. I see the Cert with OpenSSL.

Also - everything works when debugging as Windows Machine, but it always fails when debugging as Android device. Using Visual Studio 2022.

Caused by: java.security.cert.CertPathValidatorException: Trust anchor for certification path not found.

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)
SCAppCo 1 Reputation point

2022-07-08T20:14:18.577+00:00

I am having the same issue with Net Maui and Microsoft.Data.SQLClient. I cannot get it to connect. I keep getting the following two errors... I am trying to connect to a SQL Server on our local network, and I have a valid DigiCert installed. I see the Cert with OpenSSL.

Also - everything works when debugging as Windows Machine, but it always fails when debugging as Android device. Using Visual Studio 2022.

Caused by: java.security.cert.CertPathValidatorException: Trust anchor for certification path not found.

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)

Answer 2

Has anyone figured this out?

error message:

Microsoft.Data.SqlClient.SqlException

Message=A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed)

Infos：

Microsoft.Data.SqlClient 5.0.1

SQL server 2019 developer

I tried:

1, put "trustServerCertificate=true" in connectionstring and installed certificates in computer, failed

2, put "encrypt = false" in connectionstring and put "android:usesCleartextTraffic ="true" " in AndroidManifest.XML , failed

In Xamarin.Forms using System.Data.SqlClient , sucessfully without any problems.

In Maui windows platform using Microsoft.Data.SqlClient , sucessfully without any problems.

If there are any suggesttions or solutions , please let me know!

Thanks everybody!

Jan Seriš 1 Reputation point

2023-01-19T08:38:34.07+00:00

See this

[https://github.com/dotnet/SqlClient/issues/1662#issuecomment-1386642404

There is a workaround with adding the certificate to your apk. It would be nice if you posted that it works in xamarin forms. That's an interesting info

Answer 3

S M Hasan 1

Hi @muhammad hamid
For SQL Connection you have to use Platform OS specification code , create a file in Windows SQL Connection file and call in your project anywhere using dependency

public class ExcelToSql : IExcelToSql

I am Not Able to connect .NET MAUI Project with MS SQL Connection.

3 answers

Activity