.net maui直连Sqlserver报错

解决方法:sqlserver 2008R2 打Sp3 的补丁

下载地址:https://www.microsoft.com/zh-cn/download/details.aspx?id=44272

Microsoft® SQL Server® 2008 R2 SP3 功能包

根据电脑架构选择安装 (2选一),一般是x64,安装完毕重启,重新测试即可.

SQLServer2008R2SP3-KB2979597-x64-CHS.exe

SQLServer2008R2SP3-KB2979597-x86-CHS.exe

连接语句参考:

ConnectionString = "server=192.168.1.41;database=AAA;user=sa;password=bbb;TrustServerCertificate=True;";

//测试语句

   using Microsoft.Data.SqlClient;


 private async void Bt_DbTestClick(object sender, EventArgs e)
    {
        try
        {
            var connectionString = "server=192.168.1.41;database=AAA;user=sa;password=bbb;TrustServerCertificate=True;";
            using (var connection = new SqlConnection(connectionString))
            {
                connection.Open();
                Console.WriteLine("Connection successful!");
            }
        }
        catch (SqlException ex)
        {
            string ero = "SQL Error Number: " + ex.Number + "\r" +
              "SQL Error Message: " + ex.Message + "\r" +
              "SQL Server: " + ex.Server + "\r" +
              "SQL State: " + ex.State + "\r" +
              "SQL Line Number: " + ex.LineNumber;
            await DisplayAlert("异常", ero, "确定");
        }
}

解决以下问题: