. net maui uses Microsoft Data.SqlClients encountered an exception when directly connecting to SQL Server

文虎 樊 0 Reputation points
2025-02-21T00:38:46.83+00:00

Microsoft.Data.SqlClient.SqlException (0x80131904): Successfully established a connection with the server, but an error occurred during the login process。 (provider: TCP provider, error: 0 - Success)

HttpClient can be accessed normally

SQL Server has not enabled SSL/TLS encryption

string ConnectionString = "Server=192.168.1.41;database=Db_Test;User Id=users;Password=users;Encrypt=False;TrustServerCertificate=False;";

try

{

 using (SqlConnection conn = new SqlConnection(ConnectionString))

 {

     conn.Open();

     SqlCommand comm = new SqlCommand();

     comm.Connection = conn;

     comm.CommandText = SQLString;

     comm.CommandType = CommandType.Text;

     comm.CommandTimeout = conn.ConnectionTimeout;

     DataSet ds = new DataSet("SQLDataSet");

     SqlDataAdapter adapter = new SqlDataAdapter();

     adapter.SelectCommand = comm;

     adapter.Fill(ds, "SQLDataSet");

     conn.Close();

     return ds;

 }

            }

            catch (Exception ex)

            {

                Error= ex.Message;

                return null;

            }

Open permissions

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android">
	<application android:allowBackup="true" android:icon="@mipmap/appicon" android:supportsRtl="true" android:networkSecurityConfig="@xml/network_security_config"></application>
	<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
	<uses-permission android:name="android.permission.INTERNET" />
	<uses-permission android:name="android.permission.ACCEPT_HANDOVER" />	
	
	<uses-permission android:name="android.permission.CAMERA" />
	<uses-feature android:name="android.hardware.camera" />
	<uses-feature android:name="android.hardware.camera.autofocus" />
	<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
	<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
	<uses-permission android:name="android.permission.MODIFY_AUDIO_SETTINGS" />
	<uses-permission android:name="android.permission.RECORD_AUDIO" />
</manifest>
.NET MAUI
.NET MAUI
A Microsoft open-source framework for building native device applications spanning mobile, tablet, and desktop.
3,942 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.