Critical error - Could not find stored procedure aspnet_CheckSchemaVersion

What is the exact error message?Check your membership database and see if the the Stored Procedure 'aspnet_CheckSchemaVersion' exists?

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

hi,

yes exist.. but when I click on 'aspnet_CheckSchemaVersion' I see at the screen the route folder with mssql17442 that is :

SQL2000 \ SQL387 \ Databases \ mssql17442 \ Stored Procedures \ [MSSql17442].[aspnet_CheckSchemaVersion]

mssql17442 is the name of my database.


I don't see the exact error message in dotnetnuke because I'm not able to login like administrator..

This is the link of my error:

http://www.informatori.info/Default.aspx?tabid=36&error=Could+not+find+stored+procedure+'aspnet_CheckSchemaVersion'.


you can see the two screendump



thank you

Post Edited (Sh@wn) : 8/17/2008 2:53:35 PM GMT

 

Hello,
This is my problem..

When I login like Administrator/host/user, I have the problem and the same when I try to register new users.

Before the database migration the website is in working order, but after domain transfer in new host provider the issue has start as I write up.

For this, my host provider help me saying:

"You may check out where 'aspnet_CheckSchemaVersion' is stated in your script and change it to 'dbo.aspnet_CheckSchemaVersion'."

But where is this script? I don't find it...

Can you help me to make this changes?



Post Edited (Sh@wn) : 8/22/2007 9:43:51 PM GMT

 

Make sure that you have specified the correct database informationin your application's connectionstring within the web.config.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Make sure that MSSQL17442 is atleast has a db_owner role,else you will have to use dbo.aspnet_CheckSchemaVersion instead ,since it is present is every database and is a member of "sysadmin" server role and should just work fine.



Vikram

DiscountASP.NET
www.DiscountASP.NET

 

the connection database is ok because I can download many files from my website.

http://www.informatori.info/Luglio_ISF.aspx

 

Hi,

the solution is...

In query analyzer I use the script:


ALTER SCHEMA dbo TRANSFER mssql17442.aspnet_CheckSchemaVersion;

and, one by one.. I have changed all my database from mssql17442 to dbo. Now it's Ok.

Regards