java+sql+用户登录失败,System.Data.SqlClient.SqlException：用户登录失败...在System.Data.SqlClient.SqlInternalConnec...

我知道这个问题之前曾被问过几次，但给出的解决方案根本没有帮助我 . 我有一个Azure数据库，当我的屏幕加载时，我得到异常错误：

System.Data.SqlClient.SqlException(0x80131904)：用户'ruan'登录失败 . at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity，SqlConnectionString connectionOptions，SqlCredential credential，Object providerInfo，String newPassword，SecureString newSecurePassword，Boolean redirectedUserInstance，SqlConnectionString userConnectionOptions，SessionData reconnectSessionData，DbConnectionPool pool，String accessToken，Boolean applyTransientFaultHandling)at System .Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions选项，DbConnectionPoolKey poolKey，对象poolGroupProviderInfo，池类DBConnectionPool，的DbConnection owningConnection，DbConnectionOptions USEROPTIONS)在System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(池类DBConnectionPool，的DbConnection owningObject，DbConnectionOptions选项，DbConnectionPoolKey poolKey， System.Data.ProviderBase.DbConnectionPool.CreateObject上的DbConnectionOptions(userOptions)(DbConnection owningObject，DbConnectionOptions userOptions，DbConnectionIn) System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject，DbConnectionOptions userOptions，DbConnectionInternal oldConnection)处于System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject，UInt32 waitForMultipleObjectsTimeout，Boolean allowCreate，Boolean onlyOneCheckConnection，DbConnectionOptions userOptions，DbConnectionInternal＆)中的ternal oldConnection)连接)在System.Data.ProviderBase.DbConnectionPool.TryGetConnection(的DbConnection owningObject，TaskCompletionSource1重试，DbConnectionOptions USEROPTIONS，在System.Data.ProviderBase.DbConnectionFactory.TryGetConnection DbConnectionInternal＆连接)(的DbConnection owningConnection，TaskCompletionSource1重试，DbConnectionOptions USEROPTIONS，DbConnectionInternal oldConnection，DbConnectionInternal＆连接)在System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection，DbConnectionFactory connectionFactory，TaskCompletionS)在System.Data.SqlClient的System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry)处的System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection，DbConnectionFactory connectionFactory，TaskCompletionSource1 retry，DbConnectionOptions userOptions)处的ource1 retry，DbConnectionOptions userOptions . 位于C：\ Users \ Administrator \ Desktop \ Project \ Project \ Ticketing \ Ticketing \的Ticketing.LogNewTicket.Page_Load(Object sender，EventArgs e)中System.Data.SqlClient.SqlConnection.Open()的SqlConnection.TryOpen(TaskCompletionSource1重试) LogNewTicket.aspx.cs：第62行ClientConnectionId：92cb895a-8433-45d3-9c8c-19120f9a5c19错误号码：18456，状态：1，类：14

我保证我的错误发生在这里因为它没有填充下拉列表 .

try

{

//con.Open();

ListItem blank = new ListItem("");

blank.Value = "0";

ddlPriority.Items.Add(blank);

string cmdText = "SELECT * FROM Priority ";

using (SqlConnection sqlConnection = new SqlConnection(con.ConnectionString))

{

sqlConnection.Open();

using (SqlCommand sqlCommand = new SqlCommand(cmdText, sqlConnection))

{

using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader())

{

while (sqlDataReader.Read())

{

ListItem itemPriority = new ListItem(sqlDataReader.GetString(1).ToString());

itemPriority.Value = sqlDataReader.GetInt32(0).ToString();

ddlPriority.Items.Add(itemPriority);

}

}

}

sqlConnection.Close();

}

}

catch (Exception ex)

{

lblSetPriority.Text = ex.ToString();

}

}

我的连接字符串如下所示：

我的连接字符串：

Data Source=xxx.database.windows.net;Initial Catalog=TicketsSupport;Integrated Security=False;User ID=ruan;Password=********;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False

连接到azure数据库后，在属性中从visual studio复制的连接字符串 . 将****的密码更改为实际的密码 .

在web.config中：

我尝试添加以下内容：

和

我的主数据库有一个名为“ruan”的用户

我在我的主人身上使用了以下内容：

SELECT * FROM sys.database_principals

当我添加我的用户时，我只做了以下事情：

CREATE LOGIN ruan WITH PASSWORD = 'abc123',

我不知道还有什么可以尝试的 .