## 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.

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

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