程序从网络公司交接而来,因为合同到期,那贱人直接把此数据传给我们就再也不管了,各位看看,这是怎么回事登陆ASPX显示:“/”应用程序中的服务器错误。
--------------------------------------------------------------------------------用户 'ygw' 登录失败。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 用户 'ygw' 登录失败。源错误: 执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。 堆栈跟踪:
[SqlException (0x80131904): 用户 'ygw' 登录失败。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +144
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
workclass.SqlConn.Exe_dt(String Sql) +152
html.a.GetDH() +141
html.a.Page_Load(Object sender, EventArgs e) +226
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:2.0.50727.3603; ASP.NET 版本:2.0.50727.3082
web.config部分信息如下: <authentication mode="Windows" />
<trace
enabled="false"
requestLimit="10"
pageOutput="false"
traceMode="SortByTime"
localOnly="true"
/>
<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;user id=sa;password="
cookieless="true"
timeout="20"
/>
--------------------------------------------------------------------------------用户 'ygw' 登录失败。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 用户 'ygw' 登录失败。源错误: 执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。 堆栈跟踪:
[SqlException (0x80131904): 用户 'ygw' 登录失败。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +144
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
workclass.SqlConn.Exe_dt(String Sql) +152
html.a.GetDH() +141
html.a.Page_Load(Object sender, EventArgs e) +226
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:2.0.50727.3603; ASP.NET 版本:2.0.50727.3082
web.config部分信息如下: <authentication mode="Windows" />
<trace
enabled="false"
requestLimit="10"
pageOutput="false"
traceMode="SortByTime"
localOnly="true"
/>
<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;user id=sa;password="
cookieless="true"
timeout="20"
/>
解决方案 »
- using可以释放资源
- 仅有20分 求一个ASP.NET2005+MSSQL2005 的CRM系统源代码
- =========100分求解一个关于NetWorkStream的奇怪问题==========
- 用什么控件让用户可以选择的文件夹路径啊?不用去输入。
- 诚聘 c#.net 工程师,无意勿扰,谢谢!
- IE WEB CONTROL 安装时编译有问题
- datagrid简单问题,标题,列宽
- 没有实例化???
- 在datalist中imagebutton是不是不能触发datalist的itemCommand事件!
- 有关客户端和服务器端响应问题
- iframe 导出报表
- ********HttpContext.Current.Request.Files后台检索不到
在SQL Server中添加登录用户并给其相应数据库的权限
检查sa用户
sqlConnectionString="data source=127.0.0.1;user id=sa;password="
就是这句
<add name="ConnectionString" connectionString="provider=sqloledb;data source=.;initial catalog=DB;user id=sa;pwd=123"/>
如果有将user id和pwd修改一下,catalog是要连接的数据库名,data source是连接数据库IP,.是本机,provider是连接数据库类型
如果Web.config中没有,可能是在一个连接数据库的类中直接定义的,自己找找吧
在web.config里面没有找到数据库名,实际上打开ASpx报错说的“用户 'ygw' 登录失败”里面的用户我在web.config里面根本找不到,我也没在SQL2000里面建过
比如://从配置文件读取的连接字符串,再传入SqlConnection对象
string connStr = ConfigurationManager.ConnectionStrings["MirODBC"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
//-------------------
//另外的情况,直接写一个链接字符串,传入SqlConnection对象
string connStr="provider=sqloledb;data source=.;initial catalog=DB;user id=sa;pwd=123";//检查下这个有没有出问题
SqlConnection conn = new SqlConnection(connStr);
如果没有的话就从数据库连接类中开始查看 就是这个类了
或者 CTRL+F查找全网站或方案 找到你这个用户 'ygw' 去修改也行
2、看看你的程序调用sql查询是否有硬代码的连接语句
从你提供的信息,你去连接sqlserver的用户不是你config里配置的用户名
SqlConnection conn = new SqlConnection(connStr);
string connStr = ConfigurationManager.ConnectionStrings["MirODBC"].ConnectionString; SqlConnection conn = new SqlConnection(connStr);
//-------------------
//另外的情况,直接写一个链接字符串,传入SqlConnection对象
string connStr="provider=sqloledb;data source=.;initial catalog=DB;user id=sa;pwd=123";//检查下这个有没有出问题
SqlConnection conn = new SqlConnection(connStr);
//从配置文件读取的连接字符串,再传入SqlConnection对象
string connStr = ConfigurationManager.ConnectionStrings["MirODBC"].ConnectionString; SqlConnection conn = new SqlConnection(connStr);
//-------------------
//另外的情况,直接写一个链接字符串,传入SqlConnection对象
string connStr="provider=sqloledb;data source=.;initial catalog=DB;user id=sa;pwd=123";//检查下这个有没有出问题
SqlConnection conn = new SqlConnection(connStr);
另外,检查下你类库是不是也有连接字符串,好比楼上的