29 Ocak 2010, Cuma
Saklı yordam 'okunur aktiviteler bulunamadı.aspnet_CheckSchemaVersion'
WinHost.com sitemi barındırmak için kullanıyorum. SQL Veritabanı/üyelik sistemi tamamen benim yerel bilgisayarda çalışıyor ama sunucuya bir işe yaramıyor. Doğru tüm adımları takip ettim. Ve benim servisi için destek temasa geçtim ama 2 hafta daha cevap yok oldu.
Ya sitemde üyelik sayfamda yeni bir kullanıcı giriş yapmaya çalıştığımda bu hatayı almaya devam ediyorum.
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) 1953274
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 4849707
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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 204
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) 954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) 175
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 137
System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) 378
System.Web.Security.SqlMembershipProvider.CheckSchemaVersion(SqlConnection connection) 89
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) 815
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) 105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) 42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) 78
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) 60
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) 119
System.Web.UI.WebControls.Login.AttemptLogin() 115
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) 118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) 166
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) 1565
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.4200; ASP.NET Version:2.0.50727.4016
Birileri bu hata oluştu (belli ki bir şey bulamıyorum...) neden ve nasıl onarabileceğimi söyleyebilir mi?
Hepinize teşekkür ederim
Bael
CEVAP
5 ŞUBAT 2010, Cuma
Winhost.com karşı aspnet_regsql.exe
'ler sql server? kaç yaptın
aspnet_regsql.exe -S DBServerName -U DBLogin -P DBPassword -A all -d DBName
Sen tabloları ve nesneleri winhost.com'server ın SQL. oluşturulan bunu çalıştırmak emin olmak gerekir
Bunu Paylaş:
Geçici Tabloya yerleştirin Saklı Yorda...
SQL Server Saklı Yordam, fonksiyon vs....
Neden saklı yordam kümesi sütunları se...
Arama SQL Server Saklı Yordam Metin...
Nasıl "yinelenen OLMADAN birden f...