ASP.NET

Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. RSS

31 replies

Last post Dec 26, 2010 07:59 PM by arkan.turk

‹ Previous Thread|Next Thread ›

zijun

0 Points

17 Posts

Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 27, 2010 10:28 AM|LINK

Server Error in '/staff' 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, RunBehavior runBehavior, Boolean returnStream, 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 updateLastLoginActivityDate, 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

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

Moved by SGWellens on Nov 27, 2010 01:13 PM

- Reply
vinodin.net

Member

186 Points

38 Posts

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 27, 2010 02:40 PM|LINK

Hi

Please run the below query in sql server ,which will return the stored procedure with name starts aspnet-------
use <YourDatabase>
go
select * from sysobjects where xtype ='P' and name like 'aspnet_%'
- Reply
zijun

0 Points

17 Posts

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 28, 2010 08:38 AM|LINK

do you know anything about the asp.net website adminstration tools?
- Reply
arkan.turk

Contributor

2996 Points

712 Posts

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 28, 2010 11:10 AM|LINK

you may use custom member ship provider so if you go to your database and open this table aspnet_SchemaVersions you will find it empty so go to this file aspnet_regsql you can found it in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727, run it with your Database to create SchemaVersions

and refer this linke

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

Do it once and do it right and forget it for ever
MCSD & MCAD
- Reply
KumarHarsh

All-Star

15133 Points

3647 Posts
Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 29, 2010 09:30 AM|LINK
I think you are using Membership or profile or persinalization features using aspnedb database.
If its working fine in local , then are you using the same datbase ?
if not then please run
```
aspnet_regsql
```
command to register all inbuiled tables,proceudre with your database .
So, its only about
```
aspnet_regsql
```
command.

refer this,

http://social.msdn.microsoft.com/Forums/en-US/asmxandxml/thread/ac0770af-a781-4558-9f2f-f8bea17665be/
Warm Regards
Kumar Harsh
- Reply
abrly

Participant

1361 Points

273 Posts

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 29, 2010 09:36 AM|LINK

Export your aspnetdb.mdf from your local machine to your webserver's database. i mean host your developement database (aspnetdb.mdf) to your production server including the data.

"The heights by great men reached and kept Were not attained by sudden flight, But they, while their companions slept, Were toiling upward in the night" - Longfellow

Solomon Akbar
Microsoft Communitiy Contributor (MCC)
- Reply
zijun

0 Points

17 Posts

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 30, 2010 04:34 AM|LINK

I had problem when i click on the security tab in the tools

this is error below

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Login failed for user 'Chan-PC\Chan'.
- Reply
zijun

0 Points

17 Posts

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 30, 2010 04:51 AM|LINK

hi kumar
<div> <div>
I had problem when i click on the security tab in the tools

this is error below

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Login failed for user 'Chan-PC\Chan'.
</div></div>
- Reply
abrly

Participant

1361 Points

273 Posts

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 30, 2010 04:53 AM|LINK

kindly check your web.config file in whether role has been enabled or not, and make sure you mentiend "applicatoin name" along with it.

<roleManager enabled="true" defaultProvider="AspNetSqlProvider">providers>clear/>add connectionStringName="LocalSqlServer" name="AspNetSqlProvider" type="System.Web.Security.SqlRoleProvider" applicationName="/unidispayqt"/>providers>roleManager>

see the application name, i guess you have not used application name in your web.config.

you need to define application name in webconfig, you can set this by WAT too.

see the membership tag bellow:

<
membership defaultProvider="AspNetSqlProvider"
>

<
providers
>

<
clear
/>

<
add name="AspNetSqlProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="LocalSqlServer" requiresQuestionAndAnswer="false" minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0" applicationName="/unidispayqt"
/>

</
providers
>

</
membership
>

"The heights by great men reached and kept Were not attained by sudden flight, But they, while their companions slept, Were toiling upward in the night" - Longfellow

Solomon Akbar
Microsoft Communitiy Contributor (MCC)
- Reply
zijun

0 Points

17 Posts

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Nov 30, 2010 05:00 AM|LINK

This is my current webconfig

anything wrong wif this

<?xml version="1.0" encoding="UTF-8"?>



<configuration>

       <connectionStrings>

        <remove name="LocalSqlServer" />

    <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=appservicesdb;Integrated Security=True" providerName="System.Data.SqlClient"/>

    <add name="ORAConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Database1.mdb;Persist Security Info=True" providerName="System.Data.OleDb" />

       </connectionStrings>

       <system.web>

<roleManager enabled="true" />

<authentication mode="Forms" />

    <identity impersonate="false"/>

    <compilation debug="true" strict="false" explicit="true" targetFramework="4.0">

                     <assemblies>

                           <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />

                           <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

                           <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /></assemblies></compilation>



       </system.web>

</configuration>

Prev Next

1 2 3 4 Last

‹ Previous Thread|Next Thread ›

Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. RSS

31 replies

zijun

Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Server Error in '/staff' Application.

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

vinodin.net

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

zijun

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

arkan.turk

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

KumarHarsh

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

abrly

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

zijun

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

zijun

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

abrly

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

zijun

Re: Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft