加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 编程开发 > asp.Net > 正文

ASP.NET – Web.config登录错误找不到存储过程’dbo.aspnet_Chec

发布时间:2020-12-16 07:31:36 所属栏目:asp.Net 来源:网络整理
导读:我正在使用表单身份验证和gettnig以下错误: Server Error in ‘/’ Application. Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’. Description: An unhandled exception occurred during the execution of the current web request. P
我正在使用表单身份验证和gettnig以下错误:

Server Error in ‘/’ Application.

Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find
stored procedure ‘dbo.aspnet_CheckSchemaVersion’.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure
‘dbo.aspnet_CheckSchemaVersion’.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) +2030802
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,Boolean breakConnection) +5009584
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.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior,String resetOptionsString) +215
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior,RunBehavior runBehavior,Boolean returnStream,Boolean
async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior,String
method,DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result,String methodName,Boolean sendToPipe) +178
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider,
SqlConnection connection,String[] features,String version,Int32&
schemaVersionCheck) +392
System.Web.Security.SqlMembershipProvider.CheckSchemaVersion(SqlConnection
connection) +84
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String
username,Boolean updateLastLoginActivityDate,Int32& status,String&
password,Int32& passwordFormat,String& passwordSalt,Int32&
failedPasswordAttemptCount,Int32& failedPasswordAnswerAttemptCount,
Boolean& isApproved,DateTime& lastLoginDate,DateTime&
lastActivityDate) +827
System.Web.Security.SqlMembershipProvider.CheckPassword(String
username,String password,
Boolean failIfNotApproved,String& salt,Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.ValidateUser(String
username,String password) +106
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs
e) +60
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs
e) +129 System.Web.UI.WebControls.Login.AttemptLogin() +127
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source,EventArgs
e) +101 System.Web.UI.Control.RaiseBubbleEvent(Object source,
EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +125
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
eventArgument) +167
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl,String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,Boolean includeStagesAfterAsyncPoint)
+5563

这是我的web.config文件中的代码:

<?xml version="1.0"?>

<configuration>
<connectionStrings>
    <add name="OleConnectionStringSource" connectionString="Data Source=alg-sql01;Initial Catalog=PriceFinder;User ID=PriceFinderUser;Password=******;Integrated Security=false"
     providerName="System.Data.SqlClient" />
    <add name="OleConnectionStringTarget" connectionString="Data Source=alg-sql01;Initial Catalog=PriceFinder;User ID=PriceFinderUser;Password=******;Integrated Security=false"
     providerName="System.Data.OleDb;" />
    <add name="PriceFinderConnectionString" connectionString="Data Source=alg-sql01;Initial Catalog=PriceFinder;Integrated Security=True"
     providerName="System.Data.SqlClient" />
    <add name="PriceFinderConnectionString2" connectionString="Data Source=alg-sql01;Initial Catalog=PriceFinder;Integrated Security=True"
     providerName="System.Data.SqlClient" />
</connectionStrings>

<system.web>
<compilation debug="true" targetFramework="4.0" />

<authentication mode="Forms">
  <forms loginUrl="~/default.aspx" timeout="2880" />
</authentication>

 <membership>
  <providers>
    <clear/>
      <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="OleConnectionStringSource"
         enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false"
         maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10"
         applicationName="/" />  
  </providers>
</membership> 

<profile>
  <providers>
    <clear/>
   <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/> 
  </providers>
</profile>

<roleManager enabled="false">
  <providers>
    <clear/>
      <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/" />
    <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/" /> 
  </providers>
</roleManager>

?????
??

我该如何解决这个错误?你需要看到任何其他文件吗?
谢谢!

解决方法

您是否在SQL-Server中创建了表和存储过程?

如果您使用MS Sql-Server作为DBMS,请查看this link并执行aspnet_regsql.exe.

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读