DotNetInvoice Forums

Trying to install DotNetInvoice 2.3 with SQL Server 2000 - compiled a web application and when go to default.aspx page and enter in username/password - get the error below 

The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'.  However, the current database schema is not compatible with this version.  You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

Checked online and made sure application name was specified in web.config and updated aspnet_schemaversions database  - any help appreciated.

made some head way - i had permission issues on the database so I changed the database user from dbo to a custom user account - this resolved the above schema error - now i get errors looking for dbo. stored procedures - i tried a search and replace in the code but only found a few - but still have problems - ie - its looking for dbo.aspnet_Membership_GetPasswordWithFormat - but i cannot find any reference to this in the application code?

Mudpatch,

aspnet_Membership_GetPasswordWithFormat is a stored procedure used by the built-in ASP.NET Membership Provider, so the code that references it is built into the .NET framework. If this stored procedure was not created then there is a problem with the your database tables or sprocs (ie, they were not all created). I would suggest deleting the database and starting the DB install from scratch (assuming you don't have production data at this point).