我知道這個問題之前曾被問過幾次,但給出的解決方案根本沒有幫助我 . 我有一個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',
我不知道還有什麼可以嘗試的 .