Developer technologies | .NET | .NET MAUI
A Microsoft open-source framework for building native device applications spanning mobile, tablet, and desktop.
The solution is to put Encrypt=False in the connexionString...
Android .NET6 Microsoft.Data.SQLClient, error during the connection to SQL Server 2019
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 15%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKT%3C/text%3E%3C/svg%3E)
Keven Thériault
1
Reputation point
I use the new stack of development Android C# (not Xamarin). I have SQL Server 2019 and Visual Studio 2022.
During the connection to the server with ADO.NET (Microsoft.Data.SQLClient) I have this error :
A connection was succesfully established with the server, but then an orror occured during the pre-login handshake TCP provider error 35
I also had this error with the stack Console .NET 6, but I solve that with add of Trust Server Certificate=true in the connection string. This solution don't resolve my problem with the Android stack. I think the problème is when client and server are on different device...
I need solution for my students !!!
Thanks !!!
Developer technologies | .NET | .NET MAUI
SQL Server | Other
-
Mike Bowen 2,056 Reputation points Microsoft Employee Moderator2022-11-10T21:53:07.84+00:00 Hi @Keven Thériault ,
The openspecs-* tags are dedicated to supporting issues related to open specifications. You can find open specifications here https://learn.microsoft.com/en-us/openspecs/
Since your question does not pertain to one of these specifications, I've removed the [openspecs-sqlserver]. If I've misunderstood your question and you believe this is related to the Open Specifications documents, please clarify, providing the document name and section with which you have the question or issue.
Best Regards,
Michael Bowen
Escalation Engineer - Microsoft Open Specifications
Sign in to comment
Answer recommended by moderator
Answer recommended by moderator
1 additional answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 83,816 Reputation points2022-11-24T18:45:25.893+00:00 On mobile apps, code can not override certificate trust. You can:
- Buy a trusted certificate for the Sqlserver
- On each mobile device install as trusted. See andriod docs for this
- Disable encryption on the Sqlserver.