Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

The error above is normally caused by a database that is not aspnet enabled. For example, currently I have a code-first database that is previously aspnet enabled then I execute update-database -targetmigration:"0", so it removes all the tables and values.

The solution is to re-enable aspnet in your database by;

1.) Running command prompt from your Visual Basic 20xx Tools folder.

2.) Execute:

aspnet_regsql.exe -S <serverName> -U <dbUser> -P <dbPassword> -A all -d <dbName>
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. Reviewed by Edward Legaspi on Saturday, September 29, 2012 Rating: 5

No comments:

Powered by Blogger.