Check Schema Version

esherr01 · August 8th, 2011, 10:26 AM

Hi:

In an attempt to create both a web host version (working but problems that I have commented out for now) and a Local Host version that I can step through looking at errors (which is not working) I get "Could not find stored procedure dbo.aspnet_CheckSchemaVersion" as an issue stopping me before I can get to the "stepping through" to trouble shoot what I have commented out in the web host version.

Google searches point me to aspnet_regsql.exe which I have run several times as per the book, to no avail?

In creating my Local Host version I merely copied my database from the web host version thinking it would be the same idea. Changed my web.config and connectionstrings and that seems Ok now. Seems that a Schema issue points to the database.

I am willing to delete database from Local Host version and recreate, but before I do I was wondering if this seems to be moving in the right direction to solve the CheckSchema issue. I just don't want to work on something that is not the issue.

does my plan seems reasonalble.

thanks,
Cliff

Imar · August 8th, 2011, 01:04 PM

Hi thanks,

How did you copy the database to the remote server? Did you copy the structure as well as the data that the tables contain?

The error message seems to suggest the structure isn't there yet. Can you confirm the tables, view, procedures and data exist?

Imar

esherr01 · August 8th, 2011, 02:28 PM

Everything on the remote server as far as logging in, is working just fine. It's just that via Browser on the remote server I cannot step through the code, thus an added feature I want to employ has merely been commented out at this point.

What I have tried to do is create and exact duplicate of the remote server version on my system for a "local host" version. I have changed connectionstrings etc. As far as the database goes I merely "copied" it to my local host folder and all of this was done to have a version I could run within VWD to step through checking variable values.

Now when I log in via my local host version (or try and create a new user account) I get the "Could not find stored procedure dbo.asnet_CheckSchemaVersion". Since I have no stored procedures, I am trying to determine the "actual" problem.

One of the things I do after logging in in is to check the Profile.Username value and if it is not in a table of mine, I try and add it to the database table.

In the web server version this works just fine with the exact code. Thus, since I am accessing my database, my sense is that the database has a problem, but not so sure what it is. Like I said I have re-run aspnet_regsql.exe (on the local version)but this doesn't seem to help.

Tables are there I have even tried to "clear" them along with the Membership and Users tables in the ASPNETDB in an effort to "start anew" as it really doesn't matter at this point what data is in my local host database as what I am after is to be able to set some breakpoints and check out variable values.

Thanks

Imar · August 8th, 2011, 03:45 PM

Quote:

Since I have no stored procedures, I am trying to determine the "actual" problem.

That *is* the actual problem. The Membership and other providers make use of stored procedures which are created either the first time you use one of the membership features (when running locally against the Sql Express edition) or when you run the aspnet_regsql tool.

The error message seems to suggest the stored procedures are missing.

How that can happen is difficult for me to say without more information such as the actual connection strings and the way you set things up (e.g. how you're accessing the remote server from your local development machine and so on). Can you elaborate on that?

Imar