September 7, 2010

System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

I deployed the DashCommerce on Godaddy Server .
when i hit for Register.aspx ( Register Link on Main page) below is the error which i got.

System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.


I my development environment I solved this error by running aspnet_regsql.exe 
and fresh install of ASP Schema table but on my Godaddy Server 
I have no permissions to run aspnet_regsql.exe 
I checked my dashcommerce database and I found that above StoredProcedure was not even there.
so I generated the Script of ASPNETDB from my local database and executed all the stored procedures .
on godaddy DB server including aspnet_CheckSchemaVersion'.

It works I got the Register.aspx Page.


No comments:

Post a Comment