{"id":176,"date":"2010-07-13T14:26:47","date_gmt":"2010-07-13T19:26:47","guid":{"rendered":"http:\/\/www.compdigitec.com\/labs\/?p=176"},"modified":"2010-07-14T08:59:38","modified_gmt":"2010-07-14T13:59:38","slug":"solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership","status":"publish","type":"post","link":"http:\/\/www.compdigitec.com\/labs\/2010\/07\/13\/solving-could-not-find-stored-procedure-dbo-aspnet_checkschemaversion-in-asp-net-membership\/","title":{"rendered":"Solving Could not find stored procedure dbo.aspnet_CheckSchemaVersion in ASP.NET Membership"},"content":{"rendered":"<p>Normally, as usual, one would not see the error <strong>Could not find stored procedure &#8216;dbo.aspnet_CheckSchemaVersion&#8217;<\/strong> if one has a good database already setup with everything good to go. However, sometime the annoying error <strong>Could not find stored procedure &#8216;dbo.aspnet_CheckSchemaVersion&#8217;<\/strong> crops up one can check the steps below to determine the root cause of the error:<\/p>\n<ol>\n<li>Try to recreate the Memberships database (<strong>ASPNETDB<\/strong>) &#8211; it may be corrupt or inaccessible:\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">C:\\Windows\\Microsoft.NET\\Framework\\v4.0.30319\\aspnet_regsql -S . -E -A mrpc<\/pre>\n<\/li>\n<li>If that does not resolve the problem for you, the you should check in your <em>web.config<\/em> file to see if added &#8220;Initial Catalog=aspnetdb&#8221; somewhere in your web.config file like this:\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">Data source=.;Integrated Security=True;Initial Catalog=aspnetdb<\/pre>\n<\/li>\n<li>Restart IIS.<\/li>\n<\/ol>","protected":false},"excerpt":{"rendered":"<p>Normally, as usual, one would not see the error Could not find stored procedure &#8216;dbo.aspnet_CheckSchemaVersion&#8217; if one has a good database already setup with everything good to go. However, sometime the annoying error Could not find stored procedure &#8216;dbo.aspnet_CheckSchemaVersion&#8217; crops up one can check the steps below to determine the root cause of the error: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[681,289,695,631,60],"_links":{"self":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts\/176"}],"collection":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/comments?post=176"}],"version-history":[{"count":0,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}