您的位置: 首页  >  技术问答  >  无法打开数据库"ASPNETDB"；登录要求.登录失败.用户"Philip-Desktop \ Philip"的登录失败

无法打开数据库"ASPNETDB"；登录要求.登录失败.用户"Philip-Desktop \ Philip"的登录失败

分类: 技术问答 • 2022-06-07 14:05:01
问题描述：

几个小时以来，我一直在努力寻找这个问题的答案...

I'm been struggling to find an answer to this problem for hours now...

在访问ASPNETDB数据库时，我通常不会收到此错误，但是不幸的是，我不知道自己做了什么更改.当我尝试访问名为Admin的文件夹中的Admin.aspx文件时，将出现错误.我已经使用网站管理工具对该文件夹设置了限制，但是当出现错误时，我将所有问题都删除了，以查看问题出在哪里，但仍然出现错误? Admin.aspx文件是唯一出现此错误的文件.

I use to not get this error while accessing the ASPNETDB database, but unfortunately I don't know what I changed. The error comes up when I try to access a file called Admin.aspx I have in a folder called Admin. I had restrictions set on this folder using the Web Site Administration Tool, but when the error came up I took them all of them off to see what the problem was and I still get the error?? The Admin.aspx file is the only one that gets the error..

我在web.config中的连接字符串是:

My connection string in web.config is: 

<add name="WIJLConnectionString1" connectionString="Data Source=localhost;Integrated Security=SSPI; Initial Catalog=ASPNETDB" providerName="System.Data.SqlClient" />

这是错误:

异常详细信息: System.Data.SqlClient.SqlException: 无法打开数据库"ASPNETDB" 登录要求.登录名 失败的.用户登录失败 "Philip-Desktop \ Philip".

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'Philip-Desktop\Philip'.

[SqlException(0x80131904):无法 打开数据库"ASPNETDB"的请求 登录名.登录失败.登录 用户失败 "Philip-Desktop \ Philip".]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException 例外，布尔值breakConnection) +5009598 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior，SqlCommand cmdHandler， SqlDataReader dataStream， BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj)+2275
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(布尔 enlistOK)+35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo，字符串newPassword， 布尔ignoreSniOpenTimeout， TimeoutTimer超时，SqlConnection owningObject)+183
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo，字符串newPassword， 布尔型redirectedUserInstance， SqlConnection owningObject， SqlConnectionString connectionOptions， TimeoutTimer超时)+239
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject，TimeoutTimer超时， SqlConnectionString connectionOptions， 字符串newPassword，布尔值 redirectedUserInstance)+195
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity 身份，SqlConnectionString connectionOptions，对象 providerInfo，字符串newPassword， SqlConnection owningObject，布尔值 redirectedUserInstance)+232
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions 选项，对象poolGroupProviderInfo， DbConnectionPool池，DbConnection owningConnection)+185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection，DbConnectionPool 池，DbConnectionOptions选项)+33 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)+524
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)+66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)+479
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)+108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outsideConnection，DbConnectionFactory connectionFactory)+126
System.Data.SqlClient.SqlConnection.Open() +125 System.Data.Common.DbDataAdapter.FillInternal(DataSet 数据集，DataTable []数据表，Int32 startRecord，Int32 maxRecords，字符串 srcTable，IDbCommand命令， CommandBehavior行为)+123
System.Data.Common.DbDataAdapter.Fill(数据集 dataSet，Int32 startRecord，Int32 maxRecords，字符串srcTable， IDbCommand命令，CommandBehavior 行为)+319
System.Data.Common.DbDataAdapter.Fill(数据集 dataSet，字符串srcTable)+92
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments 参数)+1618
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments 论据 DataSourceViewSelectCallback回调) +21 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +143 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +74 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +66 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +75 System.Web.UI.Control.EnsureChildControls() +102 System.Web.UI.Control.PreRenderRecursiveInternal() +42 System.Web.UI.Control.PreRenderRecursiveInternal() +175 System.Web.UI.Control.PreRenderRecursiveInternal() +175 System.Web.UI.Page.ProcessRequestMain(布尔 includeStagesBeforeAsyncPoint，布尔值 includeStagesAfterAsyncPoint)+2496

[SqlException (0x80131904): Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'Philip-Desktop\Philip'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009598 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +183
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
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) +33 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +123
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +319
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1618
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +21 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +143 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +74 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +66 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +75 System.Web.UI.Control.EnsureChildControls() +102 System.Web.UI.Control.PreRenderRecursiveInternal() +42 System.Web.UI.Control.PreRenderRecursiveInternal() +175 System.Web.UI.Control.PreRenderRecursiveInternal() +175 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2496

请有人帮忙！！我现在很绝望

Someone please help!! I'm desperate at this point

答

错误消息尽可能清楚:

无法打开数据库"ASPNETDB" 登录要求.登录名 失败的. 用户登录失败 'Philip-Desktop \ Philip'

Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'Philip-Desktop\Philip'

不允许该Windows用户连接到该数据库并使用它.

That Windows user isn't allowed to connect to that database and use it.

检查以确保:

  • 在连接字符串中具有正确的服务器名称.真的是localhost吗?还是您可能安装了SQL Server Express，并且最终以(local)\SQLExpress代替了??

  • that you have the proper server name in your connection string. Is it really localhost? Or did you perhaps install SQL Server Express and it ended up being (local)\SQLExpress instead??

您要连接的服务器具有Philip-Desktop\Philip的登录名(在Object Explorer -> (your server) -> Security -> Logins中签入)

that the server you're connecting to has a login for Philip-Desktop\Philip (check in Object Explorer -> (your server) -> Security -> Logins)

数据库 ASPNETDB拥有基于该登录名的用户，以便您可以使用该数据库(在Object Explorer -> (your server) -> Databases -> (your database) -> Security -> Users中签入)

that the database ASPNETDB has a user based on that login so that you can use that database (check in Object Explorer -> (your server) -> Databases -> (your database) -> Security -> Users)

您的admin.aspx页面确实引用了您指定的连接字符串(WIJLConnectionString1).在Admin文件夹中是否有单独的web.config，例如具有不同的连接字符串，并且admin.aspx页引用了该连接字符串?

that your admin.aspx page is truly referencing that connection string you've given (WIJLConnectionString1). Is there by any chance a separate web.config in your Admin folder that e.g. has a different connection string, and the admin.aspx page references that connection string instead??

相关推荐