Question

asp.net 用户sa登录失败

源错误: 行 39: U_User objUser = new Select().From<U_User>().Where("Login").IsEqualTo(username).And("PassWord").IsEqualTo(password).ExecuteSingle<U_User>()；
堆栈跟踪:
[SqlException (0x80131904): 用户 'sa' 登录失败。]
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +414
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +78
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +167
System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +143
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +83
System.Data.SqlClient.SqlConnection.Open() +96
SubSonic.SqlDataProvider.CreateConnection(String newConnectionString) +76
SubSonic.SqlDataProvider.CreateConnection() +64
SubSonic.AutomaticConnectionScope..ctor(DataProvider provider) +191
SubSonic.SqlDataProvider.ExecuteScalar(QueryCommand qry) +88
SubSonic.DataService.ExecuteScalar(QueryCommand cmd) +72
SubSonic.SqlDataProvider.GetDatabaseVersion(String providerName) +92
SubSonic.DataProvider.get_DatabaseVersion() +95
SubSonic.Utilities.Utility.IsSql2005(DataProvider provider) +38
SubSonic.DataService.GetGenerator(DataProvider provider, SqlQuery sqlQuery) +229
SubSonic.SqlQuery.GetGenerator() +117
SubSonic.SqlQuery.BuildSqlStatement() +75
SubSonic.SqlQuery.BuildCommand() +49
SubSonic.SqlQuery.ExecuteReader() +64

[SqlQueryException: 用户 'sa' 登录失败。]
SubSonic.SqlQuery.ExecuteReader() +123
SubSonic.SqlQuery.ExecuteSingle() +72
login.Page_Load(Object sender, EventArgs e) in h:\襄阳\XYDC0819\XYDC\login.aspx.cs:39
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
System.Web.UI.Control.OnLoad(EventArgs e) +92
BLL.BasePage.OnLoad(EventArgs e) in h:\襄阳\XYDC0819\XYDC\App_Code\BLL\BasePage.cs:31
System.Web.UI.Control.LoadRecursive() +54
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772
求解答~

Answer 1

1. 检查你数据库服务是否开启

2. 检查用户名密码是否正确