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 | 18 Comments »

18 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. สล็อตแตกง่าย Says:
    February 15th, 2022 at 01:54

    … [Trackback]

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

  8. สล็อตวอเลท ไม่มีขั้นต่ำ Says:
    March 18th, 2022 at 22:01

    … [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. bdsm Says:
    May 11th, 2022 at 06:53

    … [Trackback]

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

  10. prima diet reviews Says:
    June 17th, 2022 at 13:31

    … [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/ […]

  11. sbo Says:
    July 15th, 2022 at 05:54

    … [Trackback]

    […] Find 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/ […]

  12. sbo Says:
    July 25th, 2022 at 16:39

    … [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/ […]

  13. iptv testline Says:
    July 26th, 2022 at 07:45

    … [Trackback]

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

  14. sbobet Says:
    August 4th, 2022 at 14:30

    … [Trackback]

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

  15. ทางเข้า maxbet Says:
    August 5th, 2022 at 18:20

    … [Trackback]

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

  16. zushilato cake cart Says:
    August 29th, 2022 at 07:05

    … [Trackback]

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

  17. Alphabay Market Says:
    August 31st, 2022 at 10:38

    … [Trackback]

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

  18. Buy research chemical online Melbourne Says:
    August 31st, 2022 at 11:46

    … [Trackback]

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

Comments