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

I'm new to ASP.NET/MSSQL, I'veedited and posted Microsofts Small Business Kit. An error occurs when an attempt to Login or view the Shopping Cart. The Source Error is different for each instance but the Exception Detail is the same- System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. The Login and Cart are items I added that worked on theLocal machine but do not when running on the host.

Does anyone know why I'm getting these errors?

 

No I did not synq the DB objects. How do you do this?


The app is accessing the DB with the Catalog/Items and is functioning correctly. There are 2 DB's, one for the Catalog/Items and 1 for the Login, I plan to merge them once everything is working. When theapp trys to access the Login DB is when the errors occur.


I found a Help reference to ASPNetSqlProvider and CheckSchema, this may be where the problem is as membership is stored in the Login DB. Is it possible this is what's causing the errors?

 

Hi,
For syncing data SQL Servers, except for the Express versions, can connect to each other and pump data.
If the Express versions are used scripts need to be used.


As for the provider error, please take a look at this and see if it helps at all:
http://msdn.microsoft.com/en-us/library/system.web.security.sqlroleprovider.aspx
Salute,
Mark

 

Hi,
Did you sync your local DB objects to a SQL Server here?
Salute,
Mark

 

I found a fix for the problem but can't get Microsoft's app to find any DB's. Has anyone ever used aspnet_regsql.exe? How do I get it to find a DB?


Here's a link to the fix


http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

 

I created a video here on how to use that and many developers have said it helped them:
http://iis7testcom.web701.discountasp.net/membershipprovider/

More to come, lots more actually.
Salute,
Mark

 

All I get are SQl errors when attempting to run cmd app! It connects to the DB but can't execute any of the commands.

 

Open a support ticket, my guess is this has something to do with your OS/Firewall.

In that video I'm using Vista SP1, Windows OneCare and hard-wired (Cat6) to a Linksys Broadband router.
Salute,
Mark