“/NewsRelease”应用程序中的服务器错误。
--------------------------------------------------------------------------------无法打开登录所请求的数据库 "WebNews"。登录失败。
用户 'sa' 登录失败。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 无法打开登录所请求的数据库 "WebNews"。登录失败。
用户 'sa' 登录失败。源错误:
行 234: //判断数据库连接状态
行 235: if (conn.State != ConnectionState.Open)
行 236: conn.Open();
行 237:
行 238: cmd.Connection = conn;
源文件: F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsSQLServerDAL\SqlHelper.cs 行: 236 堆栈跟踪:
[SqlException (0x80131904): 无法打开登录所请求的数据库 "WebNews"。登录失败。
用户 'sa' 登录失败。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +821651
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
NewsSQLServerDAL.SqlHelper.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) in F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsSQLServerDAL\SqlHelper.cs:236
NewsSQLServerDAL.SqlHelper.ExecuteReader(CommandType cmdType, String cmdText, SqlParameter[] commandParameters) in F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsSQLServerDAL\SqlHelper.cs:136
NewsSQLServerDAL.SectionDAL.GetSection() in F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsSQLServerDAL\SectionDAL.cs:18
NewsBLL.Section.GetSection() in F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsBLL\Section.cs:14
_Default.Page_Load(Object sender, EventArgs e) in f:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsRelease\Index.aspx.cs:23
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 补充:我用的sql 2005 能用sa 登录 在登录属性--拥护映射了 我请求登录的数据库。我的配置文件里写的连接字符串是:<connectionStrings>
<add name="newsconnectionString" connectionString="data source=.;initial catalog=WebNews;user id=sa";/>
</connectionStrings>哪里出错了呢?现在做学习项目呢,希望很快能解决。谢谢!
--------------------------------------------------------------------------------无法打开登录所请求的数据库 "WebNews"。登录失败。
用户 'sa' 登录失败。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 无法打开登录所请求的数据库 "WebNews"。登录失败。
用户 'sa' 登录失败。源错误:
行 234: //判断数据库连接状态
行 235: if (conn.State != ConnectionState.Open)
行 236: conn.Open();
行 237:
行 238: cmd.Connection = conn;
源文件: F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsSQLServerDAL\SqlHelper.cs 行: 236 堆栈跟踪:
[SqlException (0x80131904): 无法打开登录所请求的数据库 "WebNews"。登录失败。
用户 'sa' 登录失败。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +821651
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
NewsSQLServerDAL.SqlHelper.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) in F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsSQLServerDAL\SqlHelper.cs:236
NewsSQLServerDAL.SqlHelper.ExecuteReader(CommandType cmdType, String cmdText, SqlParameter[] commandParameters) in F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsSQLServerDAL\SqlHelper.cs:136
NewsSQLServerDAL.SectionDAL.GetSection() in F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsSQLServerDAL\SectionDAL.cs:18
NewsBLL.Section.GetSection() in F:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsBLL\Section.cs:14
_Default.Page_Load(Object sender, EventArgs e) in f:\我的项目\Y2project Related\新闻网项目进程\燕\10.22pm\Y2项目\NewsRelease\Index.aspx.cs:23
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 补充:我用的sql 2005 能用sa 登录 在登录属性--拥护映射了 我请求登录的数据库。我的配置文件里写的连接字符串是:<connectionStrings>
<add name="newsconnectionString" connectionString="data source=.;initial catalog=WebNews;user id=sa";/>
</connectionStrings>哪里出错了呢?现在做学习项目呢,希望很快能解决。谢谢!
</connectionStrings>====
data source=你的sql server服务器名
加上password=""
(心不动,人不妄动)