c# - UWP SQL 连接错误 [c#]

Question

我尝试使用 SQL Server 凭据连接到 SQL Server 2008 实例。

使用 WPF 应用程序，我没有问题。

我按照这个例子: https://learn.microsoft.com/en-us/windows/uwp/data-access/sql-server-databases

我读过这个: How to connect to SQL server database from a Windows 10 UWP app

我的连接字符串是:

static private string connectionString = 
     @"Data Source=SERVER\SQLSERVER;Initial Catalog=Something;
       Integrated Security=false;Persist Security Info=True;User ID=user;Password=pass";

conn = new SqlConnection(connectionString);

try
{
    conn.Open();
}
catch(Exception z)
{
    Debug.WriteLine(z.ToString());
}

我收到这个错误

System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - L’opération a réussi)

如果我尝试

static private string connectionString = 
    @"Data Source=SERVER\SQLSERVER;Initial Catalog = Something;
      Integrated Security=true;User ID = user;Password= pass";

我收到这个错误

System.Data.SqlClient.SqlException (0x80131904): Failed to generate SSPI context. ErrorCode=DowngradeDetected

Integrated Security=SSPI 同样的错误

如果有人有想法，请问？

谢谢贝努瓦

Answer 1

您需要在 appx list 中检查访问网络资源所需的适当功能。在 VS 中打开 Package.appxmanifest 并转到“功能”选项卡。