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

6 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

    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