« Solving Handler “PageHandlerFactory-Integrated” has a bad module “ManagedPipelineHandler” in ASP.NET 4.0 | Home | ASP.NET GridView All-In-One Quick Reference »
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:
- 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
- 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
- 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 | 13 Comments »
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”.
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.
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
April 4th, 2012 at 14:55
Thank you so much. It helps solving my problem~~ I have been searching for hours
April 25th, 2012 at 04:12
Will any of these two steps make any negative changes? im a newbie when it comes to Sharepoint
January 10th, 2013 at 06:15
worked like magic! thanks
July 15th, 2024 at 09:51
… [Trackback]
[…] There you will find 25142 additional Information to that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]
August 21st, 2024 at 00:24
… [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/ […]
August 27th, 2024 at 18:24
… [Trackback]
[…] Find More Info here to that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]
September 1st, 2024 at 11:14
… [Trackback]
[…] Info on that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]
September 20th, 2024 at 22:27
… [Trackback]
[…] Read More Information here on that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]
September 21st, 2024 at 00:22
… [Trackback]
[…] Read More on to that Topic: compdigitec.com/labs/2010/07/13/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership/ […]
October 1st, 2024 at 12:40
… [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/ […]