Compdigitec Labs

« | Home | »

Solving Could not find stored procedure dbo.aspnet_CheckSchemaVersion in ASP.NET Membership

By admin | July 13, 2010

Normally, as usual, one would not see the error Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’ if one has a good database already setup with everything good to go. However, sometime the annoying error Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’ crops up one can check the steps below to determine the root cause of the error:

  1. Try to recreate the Memberships database (ASPNETDB) – it may be corrupt or inaccessible: 
    C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regsql -S . -E -A mrpc
  2. If that does not resolve the problem for you, the you should check in your web.config file to see if added “Initial Catalog=aspnetdb” somewhere in your web.config file like this: 
    Data source=.;Integrated Security=True;Initial Catalog=aspnetdb
  3. Restart IIS.

If you found this article helpful or interesting, please help Compdigitec spread the word. Don’t forget to subscribe to Compdigitec Labs for more useful and interesting articles!

Topics: Windows | 11 Comments »

11 Responses to “Solving Could not find stored procedure dbo.aspnet_CheckSchemaVersion in ASP.NET Membership”

  1. Raymond Sassine Says:
    July 28th, 2010 at 07:24

    In “1” above:
    C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regsql -S . -E -A mrpc

    after the “-S” replace the “.” with your database like: “MyMachine\SQLEXPRESS”.

  2. Ernest Says:
    November 23rd, 2011 at 01:37

    hi
    you guys are awesome, I just did the second spet and it was my answer, I wa susing my own db intead of the one I should

    thank you so much.

  3. raimondo Says:
    January 2nd, 2012 at 21:19

    He guys. THX a lot. I was searching for hours.
    In my Silverlight-App, I needed both steps, aspnet_regsql & Initial Catalog=aspnetdb

  4. Ying Says:
    April 4th, 2012 at 14:55

    Thank you so much. It helps solving my problem~~ I have been searching for hours

  5. Lucas Says:
    April 25th, 2012 at 04:12

    Will any of these two steps make any negative changes? im a newbie when it comes to Sharepoint

  6. tsahi Says:
    January 10th, 2013 at 06:15

    worked like magic! thanks

  7. ezybet Says:
    November 12th, 2024 at 02:31

    … [Trackback]

    […] Find More on that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]

  8. jeeter juice carts review Says:
    November 13th, 2024 at 00:55

    … [Trackback]

    […] Find More to that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]

  9. เน็ต AIS Says:
    November 16th, 2024 at 05:03

    … [Trackback]

    […] Read More here on that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]

  10. online shows Says:
    November 30th, 2024 at 12:48

    … [Trackback]

    […] Read More Info here on that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]

  11. tga168 Says:
    December 11th, 2024 at 22:02

    … [Trackback]

    […] Info on that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]

Comments