Could not find stored procedure dbo.aspnet_CheckSchemaVersion.

I created new database in sql server 2005 dev. edition and useaspnet_regsql to configure my database to store information for ASP.NETmembership.Than i created simple asp.net login application and thatwork fine on my local machine but when i deploy it on host server thani got this message :

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

please help.

Likely, your server is using a beta version of the asp.net SQL stuff (or your local machine is).

This post:

http://forums.asp.net/926578/ShowPost.aspx

Discusses the problem...

|||

Two ways:

1. Open file Web.config: (if you use SQL Server 2000 Professional)

<connectionStrings>
<add name="SqlClient" providerName="System.Data.SqlClient" connectionString="Server=ServerName; Initial Catalog=DatabaseName; Integrated Security=SSPI; User id=tuanba; Password=tuanba"/>
</connectionStrings>

2. Open file Web.config: (if you use SQL Server 2005)

<connectionStrings>
<remove name="LocalSqlClient"/>
<add name="LocalSqlClient" providerName="System.Data.SqlClient" connectionString="Data Source=ServerName; Initial Catalog=DatabaseName; Integrated Security=SSPI; User id=tuanba; Password=tuanba;"/>
</connectionStrings>

Goodluck!