none
請教如何解決 Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. RRS feed

  • Pergunta

  • 大家好, 我是剛接觸ASP.NET的新手, 最近遇到一個很麻煩的問題, 困擾好久了.

    因為要使用登陸註冊等功能, 我在網頁裡使用了membership,provider等.

    網頁在本機測試的時候, 已經在connectionstring裡面指向了服務器的database, 而且本地測試一切順利.

    但是當將網頁文件放到服務器上後, 只要使用 VS 2008提供的login registration等控件就會出現以下錯誤:
    (這個是login時出現的錯誤)

    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) +212
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2811
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +2476460
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +2478113
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +522
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +182
       System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +621
       System.Web.Security.SqlRoleProvider.CheckSchemaVersion(SqlConnection connection) +89
       System.Web.Security.SqlRoleProvider.GetRolesForUser(String username) +1223
       System.Web.Security.RolePrincipal.IsInRole(String role) +242
       System.Web.Configuration.AuthorizationRule.IsTheUserInAnyRole(StringCollection roles, IPrincipal principal) +229
       System.Web.Configuration.AuthorizationRule.IsUserAllowed(IPrincipal user, String verb) +354
       System.Web.Configuration.AuthorizationRuleCollection.IsUserAllowed(IPrincipal user, String verb) +245
       System.Web.Security.UrlAuthorizationModule.OnEnter(Object source, EventArgs eventArgs) +11146952
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171
    

    我通過 SQL Server Management Studio檢查到的確有dbo.aspnet_CheckSchemaVersion 這個stored procedures存在.

    也已經無數次運行過 aspnet_regsql.(我在本地測試時連的服務器上的database, 應該可以確定database的存在吧?)

    請教一下可有解決方法呢?

    謝謝各位,不勝感激!
    quinta-feira, 25 de fevereiro de 2010 02:43

Respostas

Todas as Respostas